large text amount in cell will not display in the cell

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

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.
 
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.
 
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.
 
Back
Top