AutoFit Columns in 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:

sample-excel-spreadsheet-20160812-1

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:

format-autofix-option-20160812-2

You then have a spreadsheet where all the columns are sized correctly to accommodate the widest data cell:

formatted-excel-spreadsheet-20160812-3

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:

doubleclick-column-divider-20160812-4

1 Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s