Export Excel Worksheets to Separate PDFs Using Sheet Names
Question details
Export each Excel worksheet to a separate PDF file named after its worksheet.

- Product
- Microsoft Excel and Adobe Acrobat
- Device & OS
- not provided
- Scenario
- A workbook contains multiple worksheets that need to be distributed as individually named PDFs.
- Observed behavior
- The desired result is one PDF per worksheet, with each PDF named after the corresponding worksheet.
Check each worksheet's print area, page orientation, and scaling in Page Layout or Print Preview. A single worksheet can span multiple PDF pages, so splitting a combined PDF by page may not produce one file per worksheet.
Export each worksheet as a PDF manually in Excel
Use this approach for a small workbook when you want to name each PDF yourself.
Click the worksheet tab you want to export. If multiple tabs are grouped, right-click a tab and select Ungroup Sheets first.
Select File > Save As or File > Export, and choose PDF as the file type. In Options, select Active sheet(s) if that choice is available.
Enter the worksheet name as the file name, choose a destination folder, and select Save or Publish.
Click the next worksheet tab and repeat the PDF export until each sheet has its own file.

Automate separate worksheet PDFs with Excel VBA
Use this Windows desktop Excel macro to export visible worksheets to a chosen folder without naming each PDF manually.
Save individual worksheets as PDFs in WPS Spreadsheets
Open your Excel workbook in WPS Spreadsheets and export one active worksheet at a time, entering its sheet name as the PDF file name.
- 1. Open the workbook: In WPS Spreadsheets, select Menu > Open and choose your Excel workbook.
- 2. Select a worksheet: Click the tab for the worksheet you want to export and check its print layout.
- 3. Export the active sheet: Select Menu > Export to PDF. In the export settings, choose the current or active sheet rather than the entire workbook; the wording may vary by version.
- 4. Name and repeat: Enter the worksheet name as the PDF file name, choose a destination, and export. Repeat for each remaining worksheet.

Frequently Asked Questions
Can I automatically name each PDF after its worksheet?
Yes. In desktop Excel for Windows, a VBA macro can loop through worksheets and use each sheet name when calling ExportAsFixedFormat. Replace characters that Windows does not allow in file names.
Will splitting a combined PDF by page create one file per worksheet?
Only if every worksheet occupies exactly one PDF page. If a worksheet spans multiple pages, export each sheet separately or determine the page ranges before splitting in Acrobat Pro.
How do I include hidden worksheets in the VBA export?
Unhide them first by right-clicking a worksheet tab and selecting Unhide. The provided macro exports only visible worksheets.
Why does one worksheet produce a PDF with several pages?
The worksheet may exceed one printed page. In Excel, check Page Layout and File > Print for the print area, orientation, margins, and scaling before exporting.
Can I use Adobe Acrobat to name split files after Excel sheets?
Acrobat Pro can split PDFs, but a combined PDF does not necessarily preserve a usable mapping between pages and worksheet names. Automatic naming may require an Excel VBA or Acrobat JavaScript solution tailored to the workbook and Acrobat version.




