Spreadsheets often contain extensive data models, staging calculations, reference tables, and confidential financial metrics alongside the final summary figures. When sharing a report with managers, clients, or external stakeholders, exporting the entire workbook or even an entire worksheet to PDF can inadvertently expose sensitive background data or generate cluttered, multi-page documents.
Microsoft Excel includes an export setting that allows you to convert only a highlighted selection of cells into a clean, standalone PDF file. Here is how to save selected cells as a PDF in Excel.
Step-by-Step: Exporting Selected Cells to PDF in Excel
- Open your spreadsheet in Microsoft Excel.
- Click and drag your mouse cursor to highlight the exact range of cells you wish to include in the PDF export.
- Click on the File menu in the upper-left corner of the window.
- Click Export in the left sidebar, then select Create PDF/XPS Document.
- Click the Create PDF/XPS button.
- In the Publish as PDF or XPS dialogue window that appears, choose your desired save folder and enter a file name.
- Before saving, click the Options… button located beneath the file format dropdown.
- In the Options pop-up window, locate the Publish what section.
- Change the selection from Active sheet(s) to Selection.
- Click OK to confirm your selection, then click Publish.
Excel will compile only the highlighted cells into your new PDF document, omitting all remaining rows, columns, and worksheets.
Alternative Method: Using the Save As Dialogue
You can also achieve the same result using Excel’s classic Save As workflow:
- Highlight your target cell range in the worksheet.
- Press the F12 key on your keyboard (or go to File > Save As > Browse) to open the Save As window.
- In the Save as type drop-down menu, select PDF (*.pdf).
- Click the Options… button that appears at the bottom of the dialogue.
- Under Publish what, choose the radio button for Selection.
- Click OK and then click Save.
How to Set a Permanent Print Area for Repeated PDF Exports
If you regularly export the same table or dashboard every week or month, you can designate it as the permanent Print Area to avoid highlighting cells manually each time:
- Highlight your desired table or range of cells.
- Navigate to the Page Layout tab on the Excel ribbon.
- In the Page Setup group, click Print Area.
- Select Set Print Area.
Once set, simply clicking File > Export > Create PDF/XPS will automatically export only your defined print area without requiring you to switch options to “Selection”. If you ever need to restore standard full-sheet exports, return to Page Layout > Print Area and click Clear Print Area.
Frequently Asked Questions
Why does my exported PDF split columns across multiple pages?
If your selected table is wide, Excel may break it into vertical chunks. To prevent this, go to the Page Layout tab, locate the Scale to Fit group, and change the Width dropdown from Automatic to 1 page before exporting.
Will hidden rows or columns inside my selection appear in the PDF?
No. Excel respects your row and column visibility. Any rows or columns hidden inside your selected range will remain hidden in the exported PDF.