Wrapped text not printing - row height not matching content

cozmo_troll
cozmo_troll used Ask the Experts™
on
Hello,

I have an excel document with lines of text in different cells. I have the cells set to wrap text. I select the whole sheet and autofit the row height. However, when I open Print Preview or Print the document, the cell content doesn't print the same as how it looks in the document. Some of the text is half hidden, and it looks as though the row height automatically changes when in Print or Print Preview.

Any help on this would be greatly appreciated. Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Awarded 2010

Commented:
What font are you using? This could be an issue from non Truetype fonts, that will render differently on screen and print
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
Hello cozmo_troll,
Is the Zoom set at anything other than 100%? If so, then you will definitely get different text breaks where the line wraps.

Although Microsoft tried real hard to get the screen display to match the printed page, they were less successful at it than Apple was. Hence the artifacts that you are complaining about.

Regards,

Brad

Author

Commented:
I am using a True Type font and the zoom is at 100% - same issue?
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
Have you tried installing the most recent printer & video drivers? These two have to interact so that what you see on the screen matches what prints on the page.

Author

Commented:
byundt - the printer/video drivers wouldn't have anything to do with this error as the print preview is showing me how the document prints as well - which doesn't look like the actual document view. It is in Print and Print Preview that the cells' content gets scrunched or semi-hidden.
Most Valuable Expert 2011
Awarded 2010

Commented:
The print preview will very much depend on the printer driver, since it will try to render what you will get on the printer that you have installed.
The Print Preview and the actual print are exactly the same. The difference in view is from when you view the document itself compared to how it looks in the Print Preview/Printed form. When you view the doc at 100% the rows are at automatic fit height and all of the text is viewable. However, when you hit Print OR Print Preview, the row height doesn't show as it does in the actual document - some of the rows show the cells crunched and some text is half hidden.

I've manually adjusted the row heights so that when I Print OR Print Preview all of the text is visible.
Most Valuable Expert 2011
Awarded 2010

Commented:
suggest to accept bjundt's comment http:#a26433261

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial