Background Knowledge

When trying to print an entire Microsoft Excel workbook to a PDF using Adobe PDF or PDF Creator multiple PDFs are created for each worksheet instead of a single PDF file. This is caused by Excel itself on how the worksheets are setup due to one or all of the following settings, print quality, print area and page orientation for each worksheet.

Applies to:

• Microsoft Excel 2007
• Microsoft Excel 2003
• Microsoft Excel 2002
• Microsoft Excel 2000

Solution

1. Set “Print Area” for each sheet under “Page Layout/Page Setup”.
2. Set the “page orientation” under “Page Layout/Page Setup” to portrait or landscape for each sheet as necessary.
3. Right click on a worksheet tab at the bottom of the screen and click on “Select All Sheets”.
4. Now under Page Layout/Page Setup set the paper size and print quality for all sheets.

Source: novaPDF Knowledge Base: Printing an entire Excel workbook to a single PDF file
Source: doPDF Forum: Trouble with Multiple Pdfs with one workbook