Excel - some text incomplete in print preview and printed

[nickytgraham]

Hi,

I couldn't see this particular issue in the forum, which surprised me as I've encountered the issue before...

I have a cell which contains text spread over a number of lines (it's actually 3 different sentences with <alt><enter> between them for visual clarity).

Wrap text is on, and the vertical alignment is 'top'. When I view the page in print preview, or actually print it, the lower half of the last line is cut in half (vertically). The same thing happens when I use the field in a pivot table.

How can I fix this, other than manual resizing? I wish Excel had cell padding or margins!

Help would be greatly appreciated, thank you.

 

[Datsmart]

What exactly is in the cell? How many characters?
Sounds like you have gone over the limit of 1024 characters. You can view more characters in the formula bar, but not in the cell proper.

 

[Datsmart]

Duplicate Post:
http://www.mrexcel.com/board2/viewtopic.php?t=247120