Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
Just a comment: "howto" as one word usually means "this is a guide" not "how do I". –  msanford Jul 8 '10 at 22:08
add comment

4 Answers 4

up vote 40 down vote accepted

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.

share|improve this answer
This is great, thanks! –  George W Bush May 12 '11 at 15:22
Great... +1 for the great answer –  Abdur Rahman Oct 31 '12 at 6:12
add comment

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

share|improve this answer
+1 I like this solution because it works on whatever range you select and you can exclude, for instance, titles that you want to span many columns. –  dkusleika Jul 8 '10 at 17:02
add comment

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.

share|improve this answer
doesn't work in 2003 –  Dave Jul 8 '10 at 16:18
It does work in 2003. In both versions, you have to make sure the whole column is selected, not just a range of cells. –  dkusleika Jul 8 '10 at 17:01
add comment

Ctrl-A on the Spreadsheet. Click Format=>Row=>Height Enter 409 or any other value. Click OK See the Magic

share|improve this answer
The question was how to adjust the size of all columns, not how to make the rows gigantic. –  MattDMo Aug 22 '13 at 2:06
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.