How do I expand all columns in Excel spreadsheet?

I have a spreadsheet with many columns. The columns are all a small standard width. Double-clicking the partition line between columns will expand the column width to encompass the longest string in that column.

Is there a shortcut to perform this operation on every column in the spreadsheet?


Solution 1:

Click where the row and column headers meet, this will select the entire sheet, like so:

alt text

Then double-click any one of the column partition lines.

I do this all the time, and it's as quick as you can get.

Solution 2:

I don't know about shortcut. I use menu.
1) Select The Full Spreadsheet
2) Select Format
3) Column
4) Autofit Selection

Solution 3:

Ctrl+A to select all cells, then press Alt+H, O, I.