Bottom of cells are truncated when printed after using auto row he

G

Gary

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

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top