large text amount in cell will not display in the cell

[Guest]

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.

 

[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.

 

[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.

 

[Dave Peterson]

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