PDF Conversion Issues

Export Excel Worksheets to Separate PDFs Using Sheet Names

Steven ParkerSteven Parker Nov 22, 2026 868 views

Question details

Export each Excel worksheet to a separate PDF file named after its worksheet.

Export Excel Worksheets to Separate PDFs Using Sheet Names
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.
Before you start

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.

Solution 1Recommended

Export each worksheet as a PDF manually in Excel

Use this approach for a small workbook when you want to name each PDF yourself.

1
Select one worksheet

Click the worksheet tab you want to export. If multiple tabs are grouped, right-click a tab and select Ungroup Sheets first.

2
Open PDF export

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.

3
Name and save the PDF

Enter the worksheet name as the file name, choose a destination folder, and select Save or Publish.

4
Repeat for the other sheets

Click the next worksheet tab and repeat the PDF export until each sheet has its own file.

Export each worksheet as a PDF manually in Excel
Check file names: If a worksheet name contains a character that your operating system does not allow in file names, replace that character when saving the PDF.
Export worksheets with WPS Office

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. 1. Open the workbook: In WPS Spreadsheets, select Menu > Open and choose your Excel workbook.
  2. 2. Select a worksheet: Click the tab for the worksheet you want to export and check its print layout.
  3. 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. 4. Name and repeat: Enter the worksheet name as the PDF file name, choose a destination, and export. Repeat for each remaining worksheet.
Create a separate PDF for each worksheet.Open and edit Microsoft Excel XLS and XLSX files.Use a familiar spreadsheet interface and review print layout before export.
microsoft office alternative - wps office

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.