File Format & Compatibility

How to Copy or Extract One Page from an Excel Document

Phi Hung Vo Sep 28, 2026 870 views

Question details

The user needs to extract a single page or specific section from an Excel document so they can easily share it with someone else.

How to Copy One Page from an Excel Document

Product: Excel
Device & OS: not provided
Scenario: Sharing a specific part or a single worksheet of a larger Excel workbook without sending the entire file.
Observed behavior: The user requires a method to isolate and export a single worksheet or print area, typically by saving it as a PDF or a separate file for easy sharing.

Before you start

Before you begin, ensure your Excel worksheet is formatted correctly for printing by checking the Page Break Preview to see exactly what content fits on the single page you want to extract.

Solution 1Recommended

Save a Specific Print Area or Worksheet as a PDF

The most reliable way to share a single Excel page while preserving its formatting is by exporting it as a PDF file.

By saving your specific selection as a PDF, you ensure the recipient cannot accidentally alter the data, and the document will look exactly as you intended on any device.

Select the target area

Open your Excel document and highlight the specific cells you want to copy, or navigate to the exact worksheet you want to extract as a single page.

Set the Print Area (Optional)

If you are only selecting a portion of a sheet, navigate to the 'Page Layout' tab, click 'Print Area', and select 'Set Print Area' to ensure only the selected content is included.

Save as PDF

Click on 'File' in the top menu, then choose 'Save As'. Choose your desired destination folder, and from the 'Save as type' drop-down menu, select 'PDF'.

Share the file

Locate the newly created PDF document on your computer and attach it to an email or messaging app to send to your recipient.

Save a Specific Print Area or Worksheet as a PDF

Formatting Retained: Saving as a PDF guarantees that your recipient sees the exact layout, fonts, and page dimensions you set up in Excel.

Solution 2

Copy the Worksheet to a New Excel File

If the recipient needs to edit the data themselves, you can extract the single worksheet into a brand-new Excel file.

Extract Excel Pages Easily

Extract and Export Excel Pages Easily with WPS Office

WPS Spreadsheet provides a seamless and completely free way to extract, export, or print specific pages from your workbooks. You can easily save any selected area as a PDF or split worksheets in just a few clicks.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing Excel workbook.
2. Highlight the page content: Select the cells you want to share, or simply click on the tab of the worksheet you wish to export.
3. Export to PDF: Go to the 'Menu' or 'Tools' tab and select 'Export to PDF'. Under the export options, choose to export the 'Active sheet' or 'Selection'.
4. Save and share: Click 'Export', save the PDF file to your device, and send it to your contact via email.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Built-in, one-click Export to PDF featureIntuitive Print Preview and Page Layout controlsLightweight, fast, and completely free to use

microsoft office alternative - wps office

Frequently Asked Questions

Can I extract multiple specific pages instead of just one?

Yes. You can hold down the 'Ctrl' key while clicking multiple worksheet tabs at the bottom to select them simultaneously. Then, use the 'Save As PDF' or 'Move or Copy' method to export all the selected sheets at once.

How do I ensure my copied Excel page fits perfectly on a single PDF page?

Before exporting, go to the 'Page Layout' tab, find the 'Scale to Fit' section, and set both the Width and Height to '1 page'. This will automatically shrink or stretch your data to fit perfectly on one printed page.

Will my formulas still work if I copy a worksheet to a new file?

If you use the 'Move or Copy' feature, your formulas will usually carry over. However, if the formulas reference data on other sheets within the original workbook, they will create external links pointing back to the old file. To prevent this, you can copy the data and use 'Paste Special > Values' in the new workbook.

Document & File Issues