Solved

Excel Shrink to Fit Printing Problems

Posted on 2013-10-24
4
733 Views
Last Modified: 2013-11-06
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?
0
Comment
Question by:bnonnemann
  • 2
4 Comments
 
LVL 10

Accepted Solution

by:
mark_harris231 earned 100 total points
ID: 39597919
Sounds like a possible printer driver issue vs. Excel.  I'd suggest checking for an updated driver.
0
 
LVL 1

Assisted Solution

by:sisiliano
sisiliano earned 100 total points
ID: 39623051
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
 

Author Closing Comment

by:bnonnemann
ID: 39628533
Thanks for your help!
0
 

Author Comment

by:bnonnemann
ID: 39628537
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now