How to Fix Excel Printing Multiple PDF Files Instead of One
Question details
Printing multiple selected worksheets from Excel using the Adobe PDF printer results in multiple separate PDF files instead of a single combined PDF document.
- Product
- Microsoft Excel, Adobe Acrobat
- Device & OS
- not provided
- Scenario
- A user is trying to save or print multiple selected Excel worksheets into one continuous PDF file using a virtual PDF printer.
- Observed behavior
- Excel processes the grouped worksheets as separate print jobs, generating multiple independent PDF files rather than merging them together.
Ensure all the worksheets you want to combine have the identical page setup and print quality (DPI) settings, as differences here are the primary reason Excel splits the print job.
Use the Acrobat PDFMaker Tab in Excel
The most reliable method to convert multiple sheets into a single PDF is using the dedicated Adobe Acrobat add-in rather than relying on the virtual print function.
When Adobe Acrobat is installed, it adds a dedicated tab to Microsoft Office applications. Using this tab bypasses the standard Windows printing spooler, preventing Excel from splitting sheets with different print settings into separate files.
Navigate to the top ribbon in Microsoft Excel and click on the 'Acrobat' tab.
Click the 'Create PDF' button located within the Acrobat ribbon menu.
In the Acrobat PDFMaker dialog box, choose 'Entire Workbook' or manually select the specific worksheets you want to include.
Click 'Convert to PDF' and select a destination folder to save your single combined PDF document.
Standardize Page Setup for the Virtual Printer
If you must use the 'Print to PDF' feature, standardizing the print settings across all selected sheets forces Excel to process them as a single continuous print job.
Easily Export Entire Workbooks to a Single PDF with WPS Office
Skip the hassle of virtual printers and mismatched page setups. WPS Spreadsheet offers a built-in, native PDF converter that effortlessly saves multiple worksheets or entire workbooks into one combined PDF document without requiring Adobe Acrobat.
- 1. Open your workbook: Launch WPS Spreadsheet and open the file containing the sheets you want to convert.
- 2. Access PDF Export: Go to the 'Menu' button in the top-left corner and select 'Export to PDF'.
- 3. Choose Entire Workbook: In the Export to PDF dialog, check the option for 'Entire Workbook' to include all sheets.
- 4. Save your PDF: Click 'Export to PDF' and choose your preferred save location to generate a single combined file instantly.
Frequently Asked Questions
Why does Excel split my print job into multiple PDFs?
Excel automatically splits print jobs when grouped worksheets have different Page Setup settings. The most common discrepancies are varying Print Quality (DPI), different page orientations (Portrait vs. Landscape), or mismatched paper sizes.
Can I combine multiple separate Excel files into one PDF?
Yes. While Excel cannot do this directly, you can use Adobe Acrobat's 'Combine Files' tool to merge separate Excel files into a single PDF, or insert all the sheets into one master workbook before exporting.
How do I select multiple specific sheets to print at once?
Hold down the Ctrl key (Command key on Mac) on your keyboard and click on the sheet tabs you want to include at the bottom of the Excel window. The tabs will highlight, indicating they are grouped for batch actions like printing.
Does WPS Office require Adobe to create PDFs?
No. WPS Office features a powerful built-in PDF engine. This allows you to convert documents, spreadsheets, and presentations directly to PDF formats natively without installing any additional virtual printers or software.
