How do you auto resize cells in Excel? [duplicate]

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?

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

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