I have a cell with wrapped text content in excel and i want to format the cell so that its height will adjust to fit the text which can span several lines What is best way of using that behavior?

Best Answer

From http://support.microsoft.com/kb/149663

To adjust the height of the row to fit all the text in a cell, follow these steps.

Select the row.

In Microsoft Office Excel 2003 and in earlier versions of Excel, point to Row on the Format menu, and then click AutoFit.

In Microsoft Office Excel 2007, click the Home tab, click Format in the Cells group, and then click AutoFit Row Height.

Also Works when all the rows are selected