«

»

Jan 29

Microsoft Excel and printing in PDF causes page splitting

More than one time I had problems printing a whole excel workbook into one PDF file. A workbook with for example 6 sheets are saved in 3 files each with 2 pages.

So, I looked up and compared the settings of all worksheets and noticed, that one has a different print quality than the others. You can find these option in the ribbon page layout, scale to fit by clicking on the little arrow in the bottom right corner.
Entering page setup - Screenshot 1
Alternatively you can just go into the printing menu and click page setup. In the first tab, called page you can set the print quality.

Print Quality in Page Setup - Screenshot 2

If you have a lot of worksheets and don’t want to click through everyone, I’ve written a short macro which replaces the print quality of each sheet. You can modify the print quality, if needed. Accepted values depending on your printer so it is possible, you get an error message.

Sub ReplacePrintQuality()
'@author Nina Ziegler
'@date 01/29/2010
'@version 1.0
'@description
' This macro loops through all worksheets in a workbook and set the print quality to 200.


For i = 1 To ActiveWorkbook.Sheets.Count
Worksheets(i).PageSetup.PrintQuality = 200
Next i
End Sub

Since Excel 2007 you can also Save your document as an PDF, which I would recommend to use.

Permanent link to this article: http://project89.com/microsoft-excel-printing-pdf-pag-splitting-48/

1 comment

  1. Anonymous

    Thank you so much. The page setup DPI is what is was.

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>