Excel Shrink to Fit Printing Problems

A user has a simple spreadsheet in Excel 2010.

Selecting a print area, and using the 'Shrink to fit' option generates the expected results on the screen.   Printing to a PDF file generates the expected results as well -- it compressed  2 pages down to a single one.

However, if you try and print to a printer, it prints one line per page and the printer spews out over 50 pages.  It also appears that only the 1st column prints as well...

As a work-around, they are printing from the PDF file, but that is not a long term answer.

What could be causing this?
bnonnemannAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mark_harris231Connect With a Mentor Commented:
Sounds like a possible printer driver issue vs. Excel.  I'd suggest checking for an updated driver.
0
 
sisilianoConnect With a Mentor Commented:
I would go for what mark suggested.

Have you tried to print this same file from another pc to the same printer? Or from same pc to a different printer if possible?
0
 
bnonnemannAuthor Commented:
Thanks for your help!
0
 
bnonnemannAuthor Commented:
Printer was redirected across a VPN and across domains -- none of the printer characteristics showed up on the client, so apparently Excel had nothing to base its pagination on.
0
All Courses

From novice to tech pro — start learning today.