Unfortunately, you're experiencing one of the trade offs using merged cells,
and you're left with having to resize the row manually.

Personally, I try to avoid using merge cells at all as they merely
complicate things. In many cases you can get the format you want by using
Center Across Selection
--
Kevin Backmann


"Ann" wrote:

HELP - I'm formatting an Excel spreadsheet. I have some merged cells that
have text in it that I want to wrap. I've selected wrap text on the
fomatting menu....and the text does wrap, but the cell doesn't expand to show
the wrapped text? I've tried selecting the row and formatting it to "auto
fit", but that doesn't work either. How do I get the cell to expand to show
that wrapped text? I'm open to just about anything at this point. Any help
is appreciated. Thanks,