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.

In article ,
"dbelch01" wrote:

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?