How to Stop Excel From Exporting Extra Blank PDF Pages
Question details
The user needs to prevent Excel from generating additional blank pages or unselected worksheets when exporting a document to PDF.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Exporting or saving specific worksheets, charts, or cell ranges as a PDF document.
- Observed behavior
- The resulting PDF contains extra blank pages or includes worksheets that were not intended to be exported.
Before exporting your workbook to PDF, switch to Page Break Preview mode in Excel to get a clear visual representation of exactly what will be printed or saved, making it easier to spot stray pages.
Define Print Area and Check Page Breaks
Setting a specific print area ensures that only the data you want is included, preventing blank cells with formatting from adding extra pages to your PDF.
Excel relies on the active 'used range' and print area settings to determine what gets included in a PDF. If the print area is not explicitly defined, Excel might attempt to include empty cells that have been accidentally clicked or formatted.
Highlight the exact range of cells that contain the data you wish to export to PDF.
Navigate to the 'Page Layout' tab on the ribbon, click 'Print Area', and select 'Set Print Area'.
Go to the 'View' tab and click 'Page Break Preview'. You will see solid and dashed blue lines representing the edges of your PDF pages.
Click and drag the blue lines to enclose only your data. Any grayed-out sections outside the blue lines will no longer be exported.

Use the Built-in Export Feature Instead of Print to PDF
System PDF printers can sometimes ignore Excel's specific sheet selection rules. Using Excel's native PDF export resolves this.
Clear Formatting from Unused Cells
Invisible formatting or a rogue space in a distant cell extends the active used range, resulting in unwanted blank PDF pages.
Export Excel to PDF Seamlessly with WPS Office
WPS Office offers a built-in, highly reliable PDF converter that makes exporting selected worksheets or specific print areas straightforward, automatically bypassing the common issues that cause extra blank pages.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing .xlsx or .xls workbook.
- 2. Select the target area: Highlight the specific cell range or click the sheet tabs you wish to convert.
- 3. Click Export to PDF: Navigate to the Menu or the Home tab and select 'Export to PDF'.
- 4. Configure and Export: Choose whether you want to export the 'Active sheet' or 'Selection', preview the layout, and click 'Export' for a flawless, blank-page-free PDF.

Frequently Asked Questions
Why is my PDF showing a completely blank page at the end of the document?
This usually happens if there is accidental formatting, like a border or background color, in a cell outside your intended data range. Clearing the formatting or deleting those unused rows and columns will reset the document bounds and fix it.
How do I export only the chart on my Excel sheet to a PDF?
Click directly on the chart to select it, then go to File > Export to PDF (or Save As PDF). Excel will automatically restrict the PDF output to just the selected chart, ignoring the rest of the worksheet.
Can scaling settings cause extra blank pages in Excel?
Yes, if your document content is slightly wider or longer than your standard page size, Excel will push the overflow columns or rows to a new page. You can fix this by going to Page Layout > Scale to Fit, and setting Width to '1 page'.




