Howto expand all columns in Excel spreadsheet?

Question

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?

Answer 1

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

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.

Answer 2

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

Answer 3

Try selecting everything (CTRL + A twice rapidly, or just select the columns you want), and then double-click a partition line. In Excel 2007, that solution seems to work just fine; in other words, it automatically sizes each column to its own longest string.