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?

1

6 Answers

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.

2

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

5

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

2

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.

4

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

Select All - "Control" A

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

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy