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?
7 Answers
I have solved it like this:
Select the entire spreadsheet.
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
-
2
-
6
-
4it's not a 'automatically autoresize' it's only a 'one-shot' autoresize.– realteboNov 11, 2014 at 10:20
-
Select the data then from menu Format->Column->AutoFit.
For Excel 2010, the menu is Home, Cells, Format, AutoFit Column Width.
For Excel 2015 (Mac) Preview it is still the same menu as Excel 2 and up to 2003 so Excel 2010 looks an odd outlier
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.
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.
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
You can use keyboard commands as such:
Ctrl+A to select all/select the entire spreadsheet
Alt+H(for hometab), Then O (for format), I(for autosize width).
When you tap Alt you get all the keyboard letter commands right on the ribbon.
keyboard commands are much faster once you get used to them.
-
While incomplete (it doesn't contain the ctrl-A to select all which is necessary for this to work), it IS useful as this is the keyboard shortcut in Excel 2010 for autosize width - a useful bit of knowledge that isn't currently present in any of the other answers.– BenJul 3, 2015 at 16:00
-
As Dunc answer didn't work for me and other answers are incomplete:
- Select cells you want to auto resize or CTRL + a for all cells
- Menu Home tab -> Format->Column->AutoFit Row/Column Height