Can I use Excel to print several sheets in a single PDF?
There is an issue when the option to print the Entire Workbook to PDF is selected for Excel Workbooks that feature multiple/individual sheets. The output is a PDF that contains only part of the Excel document, or each sheet is saved as a different PDF file.
Excel assumes that individual sheets have different page setups, and sends them as multiple print jobs as a result.
The same page setup must be used for each page in order to print individual sheets in a single PDF file:
1. Open the Excel Workbook.
2. Right-click the tab for a sheet in the workspace. A submenu will be displayed.
3. Click Select all Sheets.
4. Click File in the Menu Toolbar. A submenu will be displayed.
5. Click Page Setup.
6. Determine the print settings and ensure the Print Quality is the same for all pages.
7. Press OK. (Please note that this is necessary even when nothing has changed, because it is how Excel understands that all sheets have the same page setup options).
8. Click File in the Menu Toolbar. A submenu will appear.
9. Click Print. The software will prompt for further information.
10. Select Entire Workbook in the Print What option.
11. Click OK.
More Like This
- KB#362: How do I use the PDF-XChange printers to convert MS Office documents to PDF?
- KB#358: Why can't I print PDF documents correctly from Google Chrome?
- KB#414: Can I use PDF-Tools to convert PDF documents to other formats?
- KB#354: How do I create a single PDF document from multiple scanned pages?
- KB#335: Can I use PDF-Tools to remove page numbering from documents?