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 copied some data into Excel 2010. I have found that some of the cells need to be widened to allow the data to fit. How do I automatically adjust the height of the cells to fit the content?

share|improve this question

6 Answers 6

up vote 47 down vote accepted

I have solved it like this:

  1. Select the entire spreadsheet.

  2. Double click the line in the margin in between the two rows.

This auto sizes every row not just the one row that I clicked on.

You can see a video of it here: Adjusting the Row Height of Rows in Excel

share|improve this answer
    
FWIW this also works in Google spreadsheets. –  Hein Jan 4 '12 at 21:46
    
Is there a way to automate this on every file open? –  krookedking Jan 17 at 16:10

Select the data then from menu Format->Column->AutoFit

share|improve this answer

Row Heights: Highlight the rows you want to re-size. click on the ribbon's "Home" tab. In the "Cells" group, click on the "Format" icon -> a drop down menu will appear select "AutoFit Row Height".

Column widths: Highlight the columns you want to re-size. click on the ribbon's "Home" tab. In the "Cells" group, click on the "Format" icon -> a drop down menu will appear select "AutoFit Cell Width".

by the way, if you have used Word for awhile, you will recognize the drop down menu.

share|improve this answer

In the margin, where the columns are named, double-click the border of the columns that needs to be widened, same place where you would click and drag to manually resize. This will autoresize it.

share|improve this answer
2  
Thanks but I really wanted to resize the whole sheet. –  Dunc Feb 17 '11 at 14:36

As Dunc answer didn't work for me and other answers are incomplete:

  1. Select cells you want to auto resize or CTRL + a for all cells
  2. Menu Home tab -> Format->Column->AutoFit Row/Column Height
share|improve this answer

As many said:

  • Menu Home tab -> Format->Column->AutoFit Row/Column Height

But to me, the trick was to select all the rows that need to be taken into account. Note that it might be counter intuitive but the first row is not enough to let Excel figure out it must resize based on all the content in each column.

So yeah, in a nutshell, to visualize a CSV file generated automatically:

  • CTRL+A
  • Menu Home tab -> Format->Column->AutoFit Row/Column Height
share|improve this answer

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.