We are having difficulty making Excel 2000 use word wrap in a merged cell.
The cells are formatted as Text & set to word wrap before the merge.
(and are still set as above after the merge)
The row is set to Autoheight.
Once two cells are merged into one, this autoheight feature no longer works.
The text is truncated indicating that it is wrapping to the next line below
but I cannot see the text on the second line.
Word wrap works as expected in an unmerged cell. That is, the row
automatically adjusts to fit the multiple lines of text without inserting
hard returns (Alt+Enter).
I cannot double-click on the row seperator to have it automatically resize
the row height either. My only resolution is to drag the row seperator until
i like what i see.
Ideally I would prefer to find a setting in the options dialog that would
re-enable this autoheight feature on merged cells.
Does anyone know if this is possible?