Let Excel auto-size your columns for you.
by Thomas Duff on 8/12/2016
AutoFit, Microsoft Excel
It's not unusual to have an Excel spreadsheet where the columns either have too much or not enough spacing. You can manually drag the column dividers back and forth to resize them, but you can also let Excel size them automatically using the AutoFit option.
Here we have a spreadsheet that desperately needs some column resizing:
Excel spreadsheet with narrow columns
In order to resize the columns to fit the table header and data, highlight all the columns and select the Format > AutoFit Column Width option:
Excel AutoFit option
You then have a spreadsheet where all the columns are sized correctly to accommodate the widest data cell:
Excel spreadsheet after AutoFit
Sandra Mahan also showed me a second way to do the same thing. If you highlight one or more columns and then double-click on a column divider, Excel will AutoFit all the highlighted columns:
AutoFix by clicking on column dividers
Topic: One Minute Office Magic