large text amount in cell will not display in the cell

D

dbelch01

With a large amount of text in a cell, word wrap enabled, row autofit
enabled, column width 81.71, only 12 lines of text will display. The total
text will display in the formula bar. I can manually increase the row
height, but the additional text will not display. How do I increase the
amount of text displayed in an individual cell?

Thanks.
 
R

RagDyeR

Add some manual (forced) line breaks - <Alt> <Enter> - at some appropriate
places.

This will increase the amount of displayed text.
--

HTH,

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

With a large amount of text in a cell, word wrap enabled, row autofit
enabled, column width 81.71, only 12 lines of text will display. The total
text will display in the formula bar. I can manually increase the row
height, but the additional text will not display. How do I increase the
amount of text displayed in an individual cell?

Thanks.
 
J

JE McGimpsey

XL's specifications are that cells can contain 32767 characters, of
which 1024 will be displayed or printed.

You can enter a manual linefeed (Alt-Enter) at least every 1024
characters to bypass the display limit.
 
D

Dave Peterson

Add alt-enters (to force a new line within the cell) every 80-100 characters.
 

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