text format in spreadsheet cells

E

Elizabeth

I am experiencing a problem with populating cells with long text information
(hundreds of words). It will only show a portion of the text when viewing
on screen or printing the document. However, when you click on the cell, it
will display all the text. Does anyone know if there is a software limit on
visible text in a cell? I have wrapped the text and tried to resize the
cells, but nothing works.
 
R

RagDyeR

Try using some <Alt> <Enter> (forced line breaks) at appropriate places in
the text.

This should increase the amount of visible, displayed text.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I am experiencing a problem with populating cells with long text information
(hundreds of words). It will only show a portion of the text when viewing
on screen or printing the document. However, when you click on the cell, it
will display all the text. Does anyone know if there is a software limit on
visible text in a cell? I have wrapped the text and tried to resize the
cells, but nothing works.
 
F

FSt1

hi,
In excel help, type the word specifications.
from the specs...
Length of cell contents (text) 32,767 characters. Only 1,024 display in
a cell; all 32,767 display in the formula bar.

regards
FSt1
 
E

Elizabeth

Thanks very much for your help. This told me what I needed to know. It's
not what I wanted to hear, but at least I know that there isn't a way to
format the cell differently to get it to show the text.
 
E

Elizabeth

Yes, I did read your post. I thank you for your interest in helping me too.
Unfortunately, I cannot use your solution because I have way too many cells
with this condition. It would take me a very long time to complete this type
of manual formatting.

Thank you very much,
Elizabeth
 
R

Ragdyer

Would suggest you post to the programming group.
There might be a simple solution using code.
 
Top