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

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/micro...c2a071e4c9610a


Gord Dibben MS Excel MVP

On Tue, 4 Dec 2007 18:08:00 -0800, Jessica
wrote:

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