text format in spreadsheet cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
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.
 
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
 
Would suggest you post to the programming group.
There might be a simple solution using code.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Typed text appears in wrong cell 0
Cells ignore Wrap Text formatting! 2
Finding Text within an Array 2
Text in cell missing when printing 1
Printing truncates cell contents 6
Cell format - wrap text 7
Merged cell text does not wrap 1
Text in Cell -- Cut Off By Out Line of Cell 1

Back
Top