Cell won't wrap all of the text in it

[help_please]

I have a merged cell set to wrap text. Vertical alignment is set to top (I've played around with this option). I tried doing Auto Fit for height and width, but it doesn't make a difference. The cell contains a large amount of text, and it wraps until the very end. Then it just continues on the same line, so I can't see it in the actual cell. I can see it in the formula bar. Also, if I increase the width greatly, more of the text appears. There is still plenty of room in the row height, but for some reason the text won't wrap down to the next line, no matter what I try.

 

[Paul]

I have a merged cell set to wrap text. Vertical alignment is set to top

(I've played around with this option). I tried doing Auto Fit for height
and width, but it doesn't make a difference. The cell contains a large
amount of text, and it wraps until the very end. Then it just continues on
the same line, so I can't see it in the actual cell. I can see it in the
formula bar. Also, if I increase the width greatly, more of the text
appears. There is still plenty of room in the row height, but for some
reason the text won't wrap down to the next line, no matter what I try.

No need to repost, especially so quickly!
How much text (i.e. how many characters)? I think wrap will not work after
about 1024. Excel is a spreadsheet, not a word processor.
Also merged cells often cause problems.

 

[help_please]

Sorry, didn't mean to repost. There might be more than 1024 characters. I thought that might be the problem, but I just wanted to check. Thanks!

----- Paul wrote: -----

I have a merged cell set to wrap text. Vertical alignment is set to top

(I've played around with this option). I tried doing Auto Fit for height
and width, but it doesn't make a difference. The cell contains a large
amount of text, and it wraps until the very end. Then it just continues on
the same line, so I can't see it in the actual cell. I can see it in the
formula bar. Also, if I increase the width greatly, more of the text
appears. There is still plenty of room in the row height, but for some
reason the text won't wrap down to the next line, no matter what I try.

No need to repost, especially so quickly!
How much text (i.e. how many characters)? I think wrap will not work after
about 1024. Excel is a spreadsheet, not a word processor.
Also merged cells often cause problems.

 

[Dave Peterson]

Try sprinkling a few alt-enters in your text.

I can see much more than 1000 characters that way. (with a lot of sprinkles!)