How to Combine Excel Files to PDF Without Including Every Worksheet
Question details
The user wants to combine multiple Excel workbooks into a single PDF but only include the active worksheet from each file, rather than all worksheets.

- Product
- Excel / PDF Editor
- Device & OS
- not provided
- Scenario
- Combining multiple Excel files into a single PDF document.
- Observed behavior
- The PDF conversion tool imports every worksheet from the selected Excel files instead of just the active ones.
Ensure you have identified the specific worksheets you want to include in the final PDF and have saved the workbooks with those sheets active.
Export Active Sheets to PDF Before Combining
The most reliable method is to export the active sheet of each Excel file to an individual PDF first, then combine those PDFs.
Directly importing Excel files into a PDF merger often triggers default settings that convert the entire workbook. Converting each file to a PDF individually first gives you complete control over which worksheets are included.
Open the first Excel file and navigate to the specific worksheet you want to include in your final document.
Go to File > Export or File > Save As, and choose PDF as the output format.
Click on 'Options' in the save dialog. Ensure that the 'Active sheet(s)' option is selected instead of 'Entire workbook', then save the PDF.
Repeat this process for all your Excel files. Finally, open your PDF editor, select the 'Combine Files' tool, and merge the newly created PDFs into one.

Set Print Area for Specific Worksheets
Modify the print settings in your Excel workbooks so that only the desired area is recognized during the PDF merge process.
Easily Convert and Merge Excel to PDF with WPS Office
WPS Office provides a seamless built-in PDF converter that gives you precise control over which worksheets to export, making merging files a breeze without needing third-party plugins.
- 1. Open file in WPS: Open your Excel file using WPS Spreadsheet and select the worksheet you want to convert.
- 2. Export to PDF: Click on 'Menu' in the top left corner and select 'Export to PDF'.
- 3. Choose export range: In the export dialog, select 'Active sheet' under the export range options and click 'Export to PDF'.
- 4. Merge PDFs: Open WPS PDF, navigate to the 'Merge PDF' tool, add your exported files, and combine them into a single document.

Frequently Asked Questions
Why does my PDF editor pull all worksheets when merging Excel files?
When you use a 'Combine Files' tool directly on .xlsx files, the PDF software opens Excel in the background and often defaults to converting the entire workbook. Pre-exporting to PDF ensures only the desired sheets are included.
Can I combine only specific pages from an Excel file into a PDF?
Yes, you can set a Print Area in Excel or choose a specific page range when exporting to PDF. Once the specific pages are in PDF format, you can merge them easily.
Does WPS Office allow merging PDFs for free?
Yes, WPS Office includes comprehensive PDF tools, including a feature to merge multiple PDF documents into a single file quickly and efficiently.




