#199 Excel: Automatic Column Sizing

Many people probably already know that you can automatically size any column in Excel by double-clicking right edge of the desired column in the column header. But recently I’ve seen that not everyone knows how to use this trick for every column in your spreadsheet with a single action.

How It Works:

The trick for getting this to work is to select the entire worksheet by clicking Select All button and then double-clicking the boundary between any two column headings.

NOTE: The Select All button is the space in the worksheet headers above row one and to the left of column A.

See It In Action:

Here’s an example from one of my spreadsheets.

I love this trick and use it all the time. How about you? What’s your favorite method for managing your column widths?

One thought on “#199 Excel: Automatic Column Sizing

  1. Joe S. says:

    I wasn’t aware of the double-click trick, so both are great news to me. Thanks.

    Ctrl + A is the default keyboard shortcut to “Select All” in most programs including Excel.


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