Printing an entire Excel workbook to a single PDF file

Add comment

Votes: 5

Comments: 1

If you have multiple individual sheets within your Excel workbook, when you try to create a PDF and choose to print the Entire Workbook, each sheet will be saved as a different PDF file. This happens because of the way Microsoft Excel sends the print job. Excel assumes that all your individual sheets have different page setups, so it sends them as multiple print-jobs.

n order to have all the individual sheets printed within a single PDF file (not multiple PDFs) you need to set the same page setup options for all of them (page setup in Excel modifies the print size of the resulting file, so for example if you set the page layout to landscape in Excel, the printed page will be landscape but your original Excel file will still maintain the same view).

To set the same Page Setup options for all individual Excel sheets:

Open the Excel workbook
Right-click the tab for any of the sheets you have in your workspace (by default they sheet tabs are named Sheet1, Sheet2, ...)
Choose the Select all Sheets option (which will select all the sheets in your workspace, you can tell they're selected if all the sheet tabs have a white background like an active sheet tab would have)
Go to File->Page Setup, select the options you want for the resulting printed pages (or you can leave that to default) and press OK so that Excel will record the fact that all pages have the same print settings. It's important to press the OK button even if you don't change anything, because this will "tell" Excel that all the sheets have the same page setup options.
Go to File->Print Preview and see if you like the way the pages will show when printed to PDF. If you don't have any changes to the printing options go to File->Print, select the Entire Workbook option under Print What and novaPDF from the Printer name section and click OK to create the PDF file
novaPDF will ask you where to save the PDF and (if set so) it will open the PDF when it's created.

Applies to:

novaPDF (all editions)
Microsoft Excel 2007
Microsoft Excel 2003
Microsoft Excel 2002
Microsoft Excel 2000

Showing: 1-1 of 1

Comments

30 Sep, 2008 | Courval

I wanted to print a workbook with 4 sheets all in one PDF. The first sheet was in Portrait format and the last 3 landscape. This is what I have done and it works:

1. Set Print Area for each sheet
2. Set Page Set up options for each sheet individually (in particular in this case orientation [portrait / landscape] and Fit to 1 page by 1 page [in my case]
3. Follow the direction in the article linked to above and select Page Set up for all worksheets
4. Set the Paper Size and Print Quality for all sheets

The problem I was having is that one sheet had a print quality of 300 dpi while the others had 600 dpi. This was generating 2 different PDFs that would overwrite each other. The above solved my problem and resulted in 1 PDF with different page orientations.

Add comment

Others in this Category

	Convert PowerPoint to PDF (Microsoft PowerPoint presentations to PDF)
	Converting InfoPath forms to PDF with novaPDF
	When printing a PDF (created with novaPDF) from Adobe Reader, the printed information is shrinked. Why?
	Convert projects created with Microsoft Office Project to PDF files
	How to add novaPDF to the Send To context menu
	» More articles

Home / Help / Knowledge Base

Legal Notices | Terms Of Use | Privacy Policy | Sitemap