Excel wrasp text

[Larry]

Can I get Excel's "wrap text" to work on merged cells like
it does on a single cell. If I try to pick merge cells and
wrap text for several cells, the text wraps as it is typed
but once entered I only get one line unlike a single cell
where the cell height increases to accomodate the text.

 

[John Molineaux]

You're right! As you probably know, Merge Cells doesn't
automatically click the Wrap Text box in Format | Cells.
But even if you click it manually, the Format | Rows |
Autofit that works for individual cells doesn't seem to
work if the text is in a set of horizontally-merged cells.
You have to manually drag the row taller. But then you do
get wrapped text in the merged cells.

Peace!
John Molineaux