How to Save All Sheets in an Excel Workbook as One PDF on Mac
You press save as PDF on a twelve-tab workbook, open the result and find only the sheet you were looking at. Excel for Mac treats the active sheet as the default, and getting the rest requires one deliberate choice. This guide covers saving the whole workbook, saving a chosen set of tabs, and splitting a workbook into one PDF per sheet.
Quick answer: Press ⇧⌘S, set the file format to PDF, and in the export options choose Entire Workbook instead of the active sheet. To include only some tabs, Command-click their tabs first so they are grouped, then export the active sheets. Hidden sheets are not included.
Why only one sheet is exported by default
A workbook is a set of sheets, but a printer works on one thing at a time, and Excel's default is the sheet you are looking at. The PDF export follows the same logic because it is built on the print engine. Microsoft's own Mac print documentation notes that the default is to print the active sheets, and that you have to choose to print more.
Every sheet also has its own page setup. Orientation, scale, margins, print area and headers belong to each sheet separately. That matters for the rest of this guide: when you combine sheets into one PDF, each keeps its own layout, so a sheet that is fine on its own can look wrong in the combined file if it was never set up.
Method 1: Export the entire workbook
Press ⇧⌘S to open Save As.
Choose PDF in the File Format menu.
Look for the option that says what to export. The wording varies a little between versions, but you are choosing between the active sheet or sheets, the entire workbook and the current selection. Choose the entire workbook option.
Click Save.
The PDF contains every visible sheet in tab order, each starting on a new page. Open it and scroll through before you send it. If something is missing, the sheet was probably hidden. Right-click any tab and choose Unhide to bring it back.
If you cannot find the workbook option in the Save As dialog, use the print route instead: press ⌘P, check what the dialog is going to print, switch it to the entire workbook if offered, and use the PDF menu at the bottom left to choose Save as PDF.
Method 2: Group the sheets you want
If you want four of the twelve tabs, grouping is the cleanest approach.
Click the first tab you want.
Hold ⌘ and click each additional tab. Hold ⇧ and click the last tab instead if the sheets are next to each other.
The selected tabs change colour, and the title bar shows that the workbook is in group mode.
Export with the active sheets option, so Excel includes all grouped tabs.
Right-click any tab and choose Ungroup Sheets when you are done.
Take care with the last step. While sheets are grouped, anything you type or format is applied to every sheet in the group. People who forget to ungroup occasionally overwrite data on several sheets at once. If that happens, use undo with ⌘Z straight away; our guide to undo and redo in Excel for Mac explains how far back it goes.
Moving between tabs is faster from the keyboard. The shortcuts for adding sheets and switching tabs are worth knowing if you do this often.
Method 3: One PDF per sheet
Excel does not offer a one-click split into separate files. The reliable approach is manual.
Click the first sheet's tab.
Export as PDF with the active sheet option, and name the file after the sheet.
Click the next tab and repeat.
For a workbook with a handful of tabs that takes a couple of minutes. For many tabs and repeated weekly exports, it is worth looking at automating it with a macro or a Mac Shortcuts workflow, but that is a project of its own and beyond what the built-in export does.
| What you want | Method | Notes |
|---|---|---|
| Every visible sheet in one PDF | Choose Entire Workbook when exporting | Hidden sheets are left out |
| Only some sheets in one PDF | Group the tabs, then export active sheets | Command-click to pick separate tabs, Shift-click for a run of tabs |
| One PDF per sheet | Export each sheet on its own | Select the tab, export, repeat |
| A different order in the PDF | Drag the tabs into order first | The PDF follows tab order |
| Smaller file for email | Look for the minimum-size option when saving | Wording varies by version |
Check each sheet's page setup first
Because each sheet has its own layout, run through them before you export the workbook.
Orientation and scale. One landscape sheet and one portrait sheet are fine in the same PDF, but only if you set them that way. Use the method in our guide to fitting a sheet on one page on each sheet that needs it.
Print areas. A sheet with a leftover print area exports only that area. Clear it or reset it, or follow our guide to saving a selected range as a PDF.
Headers and footers. A footer with the sheet name is a good way to keep a long combined PDF readable.
Tab order. Drag the tabs into the order you want to read them, because the PDF follows it.
Common mistakes
Exporting while grouped by accident. If the title bar says Group, the active sheets option will export every grouped tab. Ungroup first unless that is the intention.
Expecting hidden sheets. Hidden sheets are left out of the entire workbook export.
Assuming one scale fits all. A sheet that needed shrinking to fit on its own still needs it inside the combined file.
Sending a huge PDF. If the file is too large to email, look for a smaller file size option in the Save As dialog, or reduce image sizes in the workbook before exporting.
Forgetting very hidden sheets and named ranges. If a sheet is marked as very hidden it will not appear in the Unhide list. That is deliberate, and if it should be in the PDF, someone with access to the file has to make it visible.
Frequently asked questions
Can I export the whole workbook as a PDF from the print dialog?
Yes. Press ⌘P, choose what to print if your version offers the choice, and use the PDF menu at the bottom left to save as PDF. The result is the same as exporting from Save As.
Will each sheet start on a new page?
Yes. Every sheet begins on a new page in the combined PDF, whatever its length.
Why are some of my sheets missing from the PDF?
They are hidden, or they have a print area that excludes the data, or they are empty. Check each tab.
Do page numbers run across all sheets?
That depends on your header and footer settings and how you have chosen to number pages. Test with a two-sheet export first, then adjust the first page number in Page Setup if needed.
Does exporting change my workbook?
No. Exporting writes a separate PDF and leaves the workbook as it was, apart from any page setup changes you made first.