Any ideas why Auto Row Height Adjust might now work properly?

[Joshua McNichols]

Office 2010.
Some of my cells are responding to Format / Autofit Row Height command and some are not. Any idea why? The formulas in both the working and non-working cells are identical, save their cell references.

The contents of the cells are returned via formula from a cell on another sheet. I wonder if somehow the row height is being drawn from the length of the formula for those cells, rather than the content. Any ideas how to remedy?

The formula in the cells failing to auto adjust row height is:
="INTRO: "&INDIRECT("'Content List'!o2")

 

[shg]

Got merged cells?

 

[Joshua McNichols]

Yes!

 

[shg]

Excel won't autofit the height of merged cells.

 

[Joshua McNichols]

Thanks again! Unmerging them worked.

 

[shg]

You're welcome. Unmerging cells is the universal solution to the problems they cause.