Solved

Excel Shrink to Fit Printing Problems

Posted on 2013-10-24
4
844 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

837 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