File Format & Compatibility

How to Save Multiple Excel Worksheets as One PDF

Maira Mehtab Sep 21, 2026 869 views

Question details

The user needs to export all the worksheets contained in an Excel workbook into a single, continuous PDF document.

Product: Excel
Device & OS: not provided
Scenario: Compiling an entire workbook of separate sheets to share or print as one cohesive PDF file rather than multiple individual documents.
Observed behavior: Looking for the exact built-in settings and steps required to bundle all active or existing sheets into one PDF export.

Before you start

Before exporting, navigate to the Page Layout tab to review the Print Area and Scaling for each worksheet to ensure your data will not be cut off in the final PDF document.

Solution 1Recommended

Use the Export to PDF/XPS Feature

This is the most direct method to export an entire workbook into a single PDF file using Excel's built-in export settings.

Navigate to the Export Menu

Open your workbook, click on the 'File' tab in the top-left corner, and select 'Export' from the left-hand menu.

Choose PDF/XPS Option

Click on 'Create PDF/XPS Document', then click the 'Create PDF/XPS' button on the right side.

Configure Entire Workbook Settings

In the Publish dialog box, click on the 'Options...' button. Under the 'Publish what' section, select 'Entire Workbook' and click 'OK'.

Publish the PDF

Choose your desired save location, enter a file name, and click 'Publish' to generate the single PDF containing all worksheets.

Solution 2

Use the Save As Option

An alternative method utilizing the standard Save As dialog box to combine and save all worksheets as one PDF.

Convert Worksheets to PDF Easily

Save Multiple Worksheets as One PDF in WPS Office

WPS Spreadsheet provides a seamless and highly intuitive way to export your entire workbook to a single PDF, ensuring perfect formatting while remaining a free and lightweight alternative.

1. Open Your Workbook: Launch WPS Spreadsheet and open the file containing the multiple worksheets.
2. Access the Export Tool: Click on the 'Menu' button in the top-left corner and select 'Export to PDF' from the dropdown list.
3. Select Entire Workbook: In the Export to PDF window, look for the Export range settings and select the 'Entire Workbook' option.
4. Export and Save: Click the 'Export to PDF' button at the bottom, choose your destination folder, and save your combined file.

Fully compatible with Microsoft Excel (.xlsx, .xls) formatsBuilt-in, one-click PDF exporter requires no extra pluginsEasy-to-use options for exporting entire workbooks or custom sheetsFree, lightweight, and fast Office suite

Frequently Asked Questions

Why are some of my sheets missing from the exported PDF?

This happens if the export setting is left on its default 'Active sheet(s)' option instead of 'Entire Workbook'. You must open the 'Options...' dialog during the export or save process and explicitly select 'Entire Workbook' to include all sheets.

Can I save only specific multiple sheets to one PDF, rather than the whole workbook?

Yes. Hold down the Ctrl key (or Cmd on a Mac) and click the specific sheet tabs at the bottom of your screen to group them. Then, go to File > Export to PDF and ensure 'Active sheet(s)' is selected in the options. Only the grouped sheets will be exported as one PDF.

How do I fix cutoff pages or columns when saving my sheets as a PDF?

Before exporting, go to the 'Page Layout' tab. Adjust your 'Print Area', set 'Orientation' to Landscape if you have many columns, or use the 'Scale to Fit' feature (e.g., set Width to 1 page) so that each worksheet fits perfectly on a PDF page.

Document & File Issues