How do I 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

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

Answer 4

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.

Answer 5

in Excel 2016 you can select all with Ctrl + A then on Home tab look for Format menu. Click and select Autofit Column Width

Answer 6

Select All - "Control" A

Expand all column width and heights "Alt" H-O-I