wrapping text in merged cells


A

Ann

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,
 
Ad

Advertisements

K

Kevin B

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top