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?