Text not all showing in cell with 240+ words

F

flstockman

I am using wrapped text in some columns in a spreadsheet and for th
first time I can recall, I am unable to display all of it. When th
number of words gets beyond approximately 175, the remaining text i
hidden behind the adjacent cells on the right as if the text was no
wrapped. I have played with alignment, fonts, column width and ro
height, without effect. Is there a cell display limit for the cells
(I'm sure I am well below the limit on cell contents)
Help appreciate
 
R

RagDyeR

A cell can *contain* in excess of 30,000 characters, but the *display* is
restricted to 1024, *UNLESS* ... you use forced line breaks sporadically
within the cell.

The occasional use of <Alt> <Enter> will increase the number of characters
that will display.
--

HTH,

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

I am using wrapped text in some columns in a spreadsheet and for the
first time I can recall, I am unable to display all of it. When the
number of words gets beyond approximately 175, the remaining text is
hidden behind the adjacent cells on the right as if the text was not
wrapped. I have played with alignment, fonts, column width and row
height, without effect. Is there a cell display limit for the cells?
(I'm sure I am well below the limit on cell contents)
Help appreciated
 
F

flstockman

I appreciate your insight. The hard page breaks had some effect, bu
may be more useful if done during the initial text entry, because I a
still unable to get the cell to display all of the text and seem to b
restricted to the character limits you mentioned.
Thank
 
D

Dave Peterson

Maybe increasing the rowheight and columnwidth will help.

And adding more alt-enters!!

(maybe a smaller font???)
 

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

Top