Wrap Text Help Needed!

B

Bruce D.

Hello,

My problem is that I have a large amount of text in one cell. I've clicked
on the wrap text box and have tried the format/row/auto fit selection also.
Not all of my text is being displayed or when I try to print . Any ideas???

Thanks
 
G

Gary''s Student

This is a well-known problem (Excel's not yours). The text is actually
there, it just doesn't show. To fix the problem, insert a hard return every
1000 characters or so.


Use ALT-ENTER as the hard return
 
K

Kevin B

There is a limit to what can be type in a cell, and a limit to what will be
displayed.

Cell limits are:

32,767 characters maximum.
Only 1,024 display in a cell
All 32,767 display in the formula bar.
 
D

Dave Peterson

If you add alt-enters to force a new line every 80-100 characters, you can see
more.
 
Top