can't see/print select text in cell

S

Sherri

I am a fairly advanced user of Excel and have 2000. I
entered 21 lines (2130 characters) of text in a cell and
applied Wrap Text to the cell. All but one of the lines
is wrapping within the cell. Anyone ever seen this happen
before?
 
G

Gord Dibben

Sherri

Excel allows 32,767 characters in a cell but will show or print only 1024(see
Help>Specifications).

One workaround is to spread a few ALT + ENTER's at spots. This will increase
the amount shown. Don't know how far this will go.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 

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

Select Text to End of Footnote 9
Word macro that can call cells out of Excel for a find and replace 0
Incomplete text wrap within a single cell 1
Controlling word wrap in a cell 2
line break does not appear in CSV 3
Visio shape text disappears upon copy paste 1
Expanding Capabilities of Wrap Text in a cell 1
Bracers before text in a single cell 1

Top