Excel Row Height: Auto Expand

I just helped a friend resolve a problem with asking Excel to auto-adjust the row height of cells in a report. It seems that no matter how much text was entered into a cell, the row height would not automatically expand to display the entire text.

Even though he had indicated Wrap Text (which is a requirement) for the cell, it would not expand.

However, note that the cell with the question is actually three (3) merged cells.

Auto-adjust does not work with merged cells.

To correct the problem, I had the user select the range of cells with questions and uncheck "Merge and Center".  This resulted in the questions being forced into Column B.

Next, select all cells in Columns C and D that are now blank, right-click your mouse and select the Delete... option.

Select "Shift cells left" and click OK.

Readjust the question column to your desired width. To initially force the row heights to adjust to the data, select all of the row numbers that you want to adjust. Double-click on one of the row separators and the rows will automatically adjust to fit the contents.

That's it!  Now, if you add or delete text in any of the question cells, the rows will automatically adjust!