Excel Shrink to Fit Printing Problems
Posted on 2013-10-24
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?