Why does Excel only export one sheet to PDF?

Excel's default PDF export targets the active sheet — the one you're currently viewing. This matches its print behavior: printing sends only the active sheet to the printer unless you explicitly select multiple sheets first. To include all sheets you need to either select them manually or use a tool that converts the full workbook by default.

Can I choose which sheets to include and which to skip?

Yes. In Excel, hold Ctrl and click the tabs you want, then export. In the online converter at excel-to-pdf.app, every sheet is included by default and you can deselect any you want to skip before generating the PDF.

Will each sheet start on a new page in the PDF?

Yes. Both Excel's built-in export and the online converter place each sheet on its own page (or set of pages if the sheet is long). Sheet names appear as page headers when that option is enabled.

Does the order of sheets in the PDF match the workbook?

Yes. Sheets appear in the PDF in the same left-to-right tab order as in the workbook. If you want a different order, rearrange the tabs in Excel before converting.

Is there a limit on how many sheets I can convert at once?

Excel's built-in export has no sheet limit. The browser-based converter at excel-to-pdf.app also has no limit — it processes the entire workbook in your browser regardless of how many sheets it contains.

How to Convert Excel to PDF with Multiple Sheets (All Tabs in One PDF)

You have a workbook with five sheets — summary, Q1, Q2, Q3, Q4 — and you need to send the whole thing as a single PDF. You hit File → Save As → PDF and open the result. Only the summary sheet is there. The quarterly data is missing.

This is the single most common surprise when converting Excel to PDF: by default, Excel only exports the active sheet. It does not warn you. It does not ask. It just silently ignores every other tab.

Here are four ways to convert all sheets — or a specific selection of sheets — into one PDF.

Method 1: Select All Sheets in Excel Before Exporting

The quickest fix inside Excel itself. No add-ins, no extra software.

Right-click any sheet tab at the bottom of the workbook.
Click Select All Sheets. Every tab becomes highlighted (the title bar shows [Group] after the file name).
Go to File → Save As (or File → Export → Create PDF/XPS).
Choose PDF as the format and save.

Every selected sheet is now in the PDF, each starting on a new page. Sheet order matches the tab order in the workbook.

Tip: to include only some sheets, hold Ctrl and click the specific tabs you want. Then export.

Method 2: Print to PDF with “Entire Workbook”

Excel's print dialog has a scope selector that most people overlook.

Go to File → Print (or press Ctrl+P).
Under Settings, the first dropdown says Print Active Sheets by default. Change it to Print Entire Workbook.
Set the printer to Microsoft Print to PDF (Windows) or choose Save as PDF in the PDF dropdown (Mac).
Click Print and choose a save location.

This method gives you a print preview so you can see exactly how each sheet will look before committing. It also respects any print areas you have set on individual sheets — useful when you want to exclude scratch data from specific tabs.

Method 3: Use Google Sheets

If you work in Google Sheets or can upload the workbook there, this method is straightforward.

Open the spreadsheet in Google Sheets (upload the .xlsx file via File → Open if needed).
Go to File → Download → PDF (.pdf).
In the export dialog, change the Export dropdown from Current sheet to Workbook.
Adjust formatting options and click Export.

Google Sheets handles the multi-sheet export natively once you switch that dropdown. The downside: complex Excel formatting (conditional formatting, custom number formats, merged cells) sometimes shifts during the Google Sheets import.

Method 4: Use a Browser-Based Converter

The fastest option when you want every sheet in the PDF without thinking about selection or print settings.

Open the Excel to PDF converter.
Drop your .xlsx, .xls, .ods, or .csv file onto the page.
All sheets are included by default. Deselect any you want to skip.
Click Convert and download the PDF.

Because the converter runs entirely in your browser, the file never leaves your machine. There is no upload, no file-size cap, and no account required. Each sheet starts on its own page with its name printed as a header. Formatting — column widths, merged cells, number formats, colors — carries over from the original workbook.

Which Method Should You Use?

Method	Best for	Includes all sheets by default?	Preserves formatting?
Select All Sheets + Save As	Desktop Excel users	No (manual step)	Yes
Print Entire Workbook	Previewing before export	Yes (once selected)	Yes
Google Sheets	Users without Excel installed	No (change dropdown)	Partial
Online converter	Quick conversion, no install	Yes	Yes

Troubleshooting: Sheets Still Missing?

If your PDF is missing sheets after following the steps above, check these common causes:

Hidden sheets. Right-click any tab and choose Unhide to see if there are hidden sheets. Hidden sheets are not included in “Select All Sheets” or “Print Entire Workbook.” Unhide them first, then re-export.
Very hidden sheets. Some workbooks use VBA to set sheets to xlSheetVeryHidden, which hides them from the right-click Unhide menu entirely. Open the VBA editor (Alt+F11), find the sheet in the Project Explorer, and change its Visible property to xlSheetVisible.
Grouped sheets came ungrouped. If you selected multiple tabs manually, clicking anywhere inside a sheet ungroups them. Make sure the tabs stay highlighted right up until you hit Save/Export.
Print area set to a subset of data. A print area on a sheet limits what gets exported. Clear it via Page Layout → Print Area → Clear Print Area if you want the full sheet in the PDF.

For a general walkthrough of Excel-to-PDF conversion, see how to convert Excel to PDF. If formatting is the problem rather than missing sheets, Excel to PDF without losing formatting covers the five most common fixes. For workbooks with very large sheets, the large-file converter handles files of any size in the browser.