Is there a shortcut in excel that will expand the column width to show the entire column header

Question

Is there a shortcut in excel that will expand all the column width(s) to show the entire column header as well as complete column data?

Now I need to go to each and every column in the excel sheet and double click on the border between every column and expand it completely to increase the column width to show the complete text in that column. I want to get this done in one click per excel worksheet

Solution 1

Click on the top left corner of the spreadsheet (left of A, and above 1)
With the entire spreadsheet selected, double click on one of the borders, and it will do it to every row or column (depending on if you clicked between rows or columns)

Solution 2

ctrl+a - To Select All
alt+o+c+a - To AutoFit collum width

Solution 3

In Excel 2007, on the Home ribbon, to the right there is a Icon that says Format. Click that to get the drop down. There is AutoFit Column Width and Row Height.

Click the triangle in the upper left of the speadsheet to select the whole sheet. Then use AutoFit.

Solution 4

Press Alt+H,O,I while on a cell on the column you want to do the auto-fit thing.

Solution 5

Step by step instructions:

• Expand the selection to the current region (using Ctrl + Shift + 8)
• Type Alt + H to select the Home tab on the Excel ribbon
• Type O to select the Format menu in the Cells sub-area
• Type I to select “autofit column width”

View more solutions

Comments

[Jamie Gorman]

Excel 2003: ALT + O + C + A

[Jamie Gorman]

Excel 2007 & 2010: ALT + H + O + I

[MrDobilina]

@Eden Just to make sure people are aware, this also works on office 365.

[CreativiTimothy]

How do I click "one of the borders?" I'm trying to click the border of the column and row, the border of the top left corner, the border of a random cell, but it's not working. Never mind. I found an image explanation in this answer here: superuser.com/a/161395/495155