How to Export an Excel Workbook to One PDF with Page Numbers
Question details
The user needs to export a multi-sheet Microsoft Excel workbook into a single, unified PDF document while ensuring that continuous or sheet-specific page numbers are accurately preserved.
- Product
- Microsoft Excel 2007
- Device & OS
- not provided
- Scenario
- Exporting an entire multi-sheet workbook for sharing or printing as a single PDF document.
- Observed behavior
- Excel 2007 either fails to export correctly or splits the worksheets into separate PDF files instead of merging them into one continuous document.
Ensure that all worksheets in your workbook have identical print settings, including margins, orientation, and print quality (DPI), as differing settings will force Excel to split the PDF.
Configure Page Setup and Use the Built-in PDF Export
Adjusting your default printer and uniformly applying page setup configurations across all sheets helps Excel process the workbook as a single print job.
In older versions like Excel 2007, the software relies heavily on the system's default printer settings to calculate page breaks. Changing the default printer from a virtual 'Print to PDF' driver to a physical printer can resolve pagination errors.
Additionally, any discrepancy in page setups (such as different DPI settings) between tabs will cause Excel to split the output into multiple PDFs.
Open your computer's 'Devices and Printers' settings, right-click on a physical hardware printer (not a virtual PDF printer), and select 'Set as default printer'.
In your Excel workbook, right-click any sheet tab at the bottom and click 'Select All Sheets' to group them. This ensures your settings apply uniformly.
Navigate to the 'Page Layout' tab and click the small dialog box launcher in the 'Page Setup' group. Ensure the Print Quality (DPI) is the same for all sheets. Then, go to the 'Header/Footer' tab and insert your desired page numbers.
Click the 'Office Button' or 'File' menu, select 'Save As', and choose 'PDF or XPS'. Click the 'Options' button in the save dialog, select 'Entire workbook', click 'OK', and then hit 'Publish'.
Easily Export Workbooks to a Single PDF in WPS Office
WPS Spreadsheet features a robust, modern PDF exporter that effortlessly combines multiple worksheets into a single, continuous PDF while perfectly preserving page numbers and formatting, bypassing the old print-driver issues of Excel 2007.
- 1. Open your Workbook: Launch WPS Spreadsheet and open your existing .xls or .xlsx workbook.
- 2. Access the Export Tool: Click the 'Menu' button in the top-left corner and select 'Export to PDF'.
- 3. Select Entire Workbook: In the Export to PDF dialog box, locate the 'Export range' setting and select 'Entire Workbook'.
- 4. Generate the PDF: Click the 'Export to PDF' button to instantly save all your worksheets together into one unified document with continuous page numbers.
Frequently Asked Questions
Why does Excel create a separate PDF file for each worksheet?
This usually occurs when worksheets within the same workbook have different Page Setup configurations. If one sheet has a different Print Quality (DPI), orientation, or margin size than the others, Excel treats them as separate print jobs and generates individual PDFs.
How do I make page numbers continuous across the whole workbook?
You must group all sheets first. Right-click any worksheet tab and click 'Select All Sheets'. Then, open 'Page Setup' from the 'Page Layout' tab and insert the page number into the Header or Footer. Because the sheets are grouped, Excel will calculate the numbering consecutively across all tabs.
Why do I need to change my default printer to a physical one?
Older versions like Excel 2007 depend on the default printer driver's metrics to determine page boundaries and scale. Virtual 'Print to PDF' drivers can sometimes provide conflicting metrics to Excel's native PDF export tool, causing pagination errors or separated files. Using a physical printer driver provides a stable reference.
