Cell Property

  • Thread starter Thread starter Paul Lee
  • Start date Start date
P

Paul Lee

After entering some text in one single cell, I can only
see the part of texts in the cell even though I
checked "Wrap Text" and increased width and height. It is
not displaying everything I typed.
Is there a limit numbers of text and lines that can be
displayed on the cell itself? and How can I fix this
issue?

thanks for your help.

paul lee
 
Left to its own devices, excel will only show about 1000 characters in a cell.

You can see more by adding alt-enters (to force a new line within the cell) to
your text.

(and if by chance, you're using merged cells, then be aware that autofitting
rowheight won't work. But you can manually increase the height to see more.)
 
Back
Top