How do you auto resize cells in Excel?

Question

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?

Answer 1

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

Answer 2

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

Answer 3

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.

Answer 4

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.