How much text is in the cells?

If over 1024 characters, Excel will truncate after approximately 1024.

To get more, Alt + ENTER every 80-100 characters.

If less than 1024 characters just add and Alt + ENTER after last character.

This gives a linefeed and should produce the space.


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 09:49:01 -0800, Gary wrote:

How can I prevent the bottom line of text cell from being trucated during
printing after using auto row height. I have tried changing word wrap and
other cell alignments. I am running Excel 2003, but have had this problem
with previous versions. It would be great if I could add a space at the
bottom of the cell when printed.