File Format & Compatibility

How to Save a Single Excel Worksheet or Page as a PDF

Bushra Parveen Sep 28, 2026 871 views

Question details

The user wants to extract a single worksheet or a specific page from an Excel workbook and convert it into a PDF format for sharing.

How to Save One Excel Worksheet or Page to a PDF

Product: Microsoft Excel
Device & OS: not provided
Scenario: Sharing a specific portion of data, such as one sheet or page, from a larger Excel file with another person without sending the entire workbook.
Observed behavior: The user needs a method to isolate specific data or the active worksheet and export it directly to a PDF file.

Before you start

Before exporting to a PDF, ensure your Excel data is properly formatted by using the Print Preview feature to check margins, page breaks, and scale.

Solution 1Recommended

Use 'Save As' to Export the Active Worksheet

This is the most straightforward method to convert your currently selected worksheet into a PDF document.

By default, Excel's Save As PDF feature only exports the currently active worksheet. This makes it incredibly easy to isolate a single tab from a multi-sheet workbook.

Select the specific worksheet

Click on the worksheet tab at the bottom of the Excel window to make it the active sheet.

Open the Save As menu

Click on the 'File' tab in the top-left corner of the ribbon and select 'Save As' from the left sidebar.

Choose PDF as the file type

In the Save As dialog box, select the folder where you want to save the file, then click the 'Save as type' dropdown menu and select 'PDF (*.pdf)'.

Verify options and save

Click the 'Options' button in the save dialog. Ensure 'Active sheet(s)' is selected under the 'Publish what' section. Click 'OK', then click 'Save'.

Use 'Save As' to Export the Active Worksheet

Quick Tip: You can quickly attach the saved PDF to an email by using your default email client to share it securely.

Solution 2

Export a Specific Print Area to PDF

Use this method when you only need to extract a specific cell range or page rather than the entire worksheet.

Built-in PDF Exporter

Easily Export Specific Excel Sheets to PDF with WPS Office

WPS Spreadsheet provides a highly intuitive, built-in tool to export exactly what you need to PDF format in just a few clicks. Whether you are extracting a selected range, an active sheet, or the entire workbook, WPS Office simplifies the process natively.

1. Open your Excel file: Launch WPS Spreadsheet and open your .xlsx or .xls file.
2. Select the target data: Click on the specific worksheet tab you want to export, or highlight the exact cell range you need.
3. Use Export to PDF: Click the 'Menu' button in the top-left corner and select 'Export to PDF'.
4. Configure and Export: In the pop-up window, select 'Active sheet' or 'Selection' under the Export range settings, then click 'Export' to save your file.

Built-in PDF conversion requires no third-party software or plugins.Fully compatible with Microsoft Excel (.xlsx, .xls) files and formats.Highly customizable export options for individual sheets, ranges, or full workbooks.Free to use and features a familiar, user-friendly interface.

microsoft office alternative - wps office

Frequently Asked Questions

Can I export multiple specific worksheets to one PDF?

Yes. Hold down the 'Ctrl' key (or 'Cmd' on Mac) and click the specific sheet tabs you want to include so they are all highlighted. Then, use the Save As PDF function, ensuring the export range is set to 'Active sheet(s)'.

Why is my PDF cutting off columns from my worksheet?

This happens when the worksheet's data width exceeds a standard page size. To fix this, go to the 'Page Layout' tab, locate the 'Scale to Fit' group, and set the 'Width' dropdown to '1 page' before saving as a PDF.

Can I email the worksheet as a PDF directly from Excel?

Yes. Instead of saving it manually first, you can go to 'File' > 'Share' > 'Email' and click 'Send as PDF'. This automatically converts the active worksheet and opens your default email client with the PDF attached.

Will saving a worksheet as a PDF alter my original Excel file?

No. Exporting or saving as a PDF simply creates a completely new, separate file in PDF format. Your original Excel workbook (.xlsx) remains unchanged and fully editable.

Document & File Issues