Merged cell text does not wrap

[Jessica]

I have a large document that has multiple cells with a large amount of text.
Each of these cells has been merged into mutliple other cells due to the
layout of the spreadsheet. I have text wrap turned on.

The problem I am having is that the last cell will not wrap.

I have tried the following:
1. Adding in hard returns (alt Enter) at the end of the text and in the
middle of the text. This still does not force the last line to wrap.
2. I have adjusted the column height, including Auto-fit, but it still won't
wrap
3. The only way I can get the text to show on the screen is if I keep
adjusting the column width. Then eventually all the text appears on the
screen but won't print to the page.

I am thinking this is all being caused by the 1,024 character visibility
limit in excel, but I was hoping someone could confirm that.

I was also hoping someone might know another work around.

Thanks

 

[Gord Dibben]

Jessica

Wrap text will work with merged cells.

What won't work is Autofit.

You need event code to make meged cells autofit.

See this google post for code.

http://groups.google.com/group/micr...e/88c2a071e4c9610a?lnk=st&q=#88c2a071e4c9610a


Gord Dibben MS Excel MVP