How to Export Every Excel Worksheet as a Separate PDF on Mac
Question details
The user needs to export a large number of Excel worksheets into individual PDF files, with each PDF file automatically named after its respective worksheet tab.
- Product
- Microsoft Excel 365
- Device & OS
- Mac
- Scenario
- Exporting an Excel workbook containing dozens of worksheets (e.g., 65 sheets) into separate PDF files without manually saving each one.
- Observed behavior
- Excel for Mac lacks a built-in, one-click feature to batch export all worksheets as separate PDFs, making the manual export process highly time-consuming.
Ensure your Excel workbook is fully saved and that you have enabled the Developer tab in Excel preferences if you plan to use a VBA macro for automation.
Automate PDF Export Using a VBA Macro
Use a Visual Basic for Applications (VBA) script to automatically loop through every worksheet and save each one as a separate PDF named after the tab.
Because Excel for Mac does not offer a native batch export feature for separate PDFs, using a VBA macro is the most efficient method for processing a large number of sheets at once.
Go to Excel > Preferences > Ribbon & Toolbar, and check the 'Developer' box in the main tabs list.
Click the Developer tab on the Excel ribbon and select 'Visual Basic'.
In the VBA editor, right-click on your workbook project in the left pane, select 'Insert', and choose 'Module'.
Paste a standard VBA loop script that iterates through 'ThisWorkbook.Sheets', defines a file path string using 'ws.Name', and executes 'ws.ExportAsFixedFormat Type:=xlTypePDF' for each sheet.
Close the VBA editor, return to your Excel workbook, click 'Macros' on the Developer tab, select your newly created macro, and click 'Run'.
Manually Export Each Worksheet as a PDF
If you only have a few worksheets, you can manually save each active sheet as a PDF using the native Save As dialog.
Simplify Excel to PDF Conversions with WPS Office
WPS Office provides a highly integrated and user-friendly interface for handling Excel-to-PDF conversions. With its advanced built-in PDF toolkit, you can easily manage, split, or export your spreadsheet data into high-quality PDFs without relying on complex VBA scripts.
- 1. Open Your Workbook: Launch WPS Spreadsheets and open your multi-sheet workbook.
- 2. Export to PDF: Click on 'Menu' in the top-left corner and select 'Export to PDF'.
- 3. Configure Export Settings: Choose whether to export the entire workbook into a single PDF or select specific active sheets.
- 4. Split PDF (Optional): If you exported the entire workbook as a single file, open it in the built-in WPS PDF tool and use the 'Split PDF' feature to instantly break it down into separate files.
Frequently Asked Questions
Can I export an entire Excel workbook as a single PDF on Mac?
Yes. Go to File > Save As, select PDF as the file format, and under the export options, choose 'Workbook' instead of 'Active Sheet'. This will save all tabs into one continuous PDF file.
Why do I get a permission error when running the VBA macro on Mac?
Excel for Mac operates in a sandboxed environment for security. You may need to grant file system access when the macro tries to save files to a specific directory. To minimize issues, try saving the PDFs to a trusted location like the Mac Documents folder.
Will the PDF formatting match my Excel print preview?
Yes, exporting to PDF relies entirely on your Page Layout settings. Ensure you have properly configured the print area, margins, and scaling for each worksheet before exporting to guarantee the resulting PDF looks correct.
