3 Ways to Adjust Column Width in Excel
Everyday Excel Skills
If you see titles that are cut off - or number signs (##) where values should be - you likely need to adjust the width of columns in your spreadsheet. You can change the width of one column or all of them.
Here are 3 ways you can change the width of columns in Excel.
1) Change Column Width Using Your Mouse
Position your mouse pointer over the right border of any column heading. When your pointer becomes a double-headed arrow, drag to adjust the column width.
To adjust the width of multiple columns, select two or more column headings then drag the border of any selected column heading to adjust the width of all of them.
2) Double-Click to Autofit Column Width
To autofit column width, double-click the right edge of any column heading. Autofit changes column width to accommodate the longest entry.
To autofit multiple columns, drag to select two or more column headings then double-click the border of any column heading in the selected range to automatically resize all of them.
3) Use the Column Width Box
To change the width of columns with more precision, right-click a column heading and select Column Width from the shortcut menu. In the Column Width dialog box, enter a custom column width by typing a number between 0 and 255.
The number you enter represents the number of characters that should be visible. This unit of measurement isn’t exact and may not reflect the width of characters using a standard font.