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.

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

share|improve this question
add comment

4 Answers

up vote 5 down vote accepted

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)

share|improve this answer
add comment

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

share|improve this answer
    
Excel 2003: ALT + O + C + A –  Eden May 21 at 7:14
    
Excel 2007 & 2010: ALT + H + O + I –  Eden May 21 at 7:15
add comment

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.

share|improve this answer
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

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.