Wrap Text Help Needed!
 

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
--
Bruce DiPaola

Wrap Text Help Needed!
 

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
--
Gary's Student


"Bruce D." wrote:

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
--
Bruce DiPaola

Wrap Text Help Needed!
 

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

Cell limits a

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


"Bruce D." wrote:

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
--
Bruce DiPaola

Wrap Text Help Needed!
 

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

Bruce D. wrote:

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
--
Bruce DiPaola

--

Dave Peterson