Printing Problems

How to Stop Excel From Exporting Extra Blank PDF Pages

Olivia MillerOlivia Miller Nov 3, 2026 875 views

Question details

The user needs to prevent Excel from generating additional blank pages or unselected worksheets when exporting a document to PDF.

How to Stop Excel From Exporting Extra Blank PDF Pages
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 you start

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.

Solution 1Recommended

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.

1
Select the target data

Highlight the exact range of cells that contain the data you wish to export to PDF.

2
Set the Print Area

Navigate to the 'Page Layout' tab on the ribbon, click 'Print Area', and select 'Set Print Area'.

3
Adjust page breaks visually

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.

4
Remove empty 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.

Define Print Area and Check Page Breaks
Verify Scaling Settings: If a column is spilling over to a blank page, go to Page Layout > Scale to Fit, and set the Width to '1 page'.
Easy PDF Exporting with WPS Spreadsheet

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. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing .xlsx or .xls workbook.
  2. 2. Select the target area: Highlight the specific cell range or click the sheet tabs you wish to convert.
  3. 3. Click Export to PDF: Navigate to the Menu or the Home tab and select 'Export to PDF'.
  4. 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.
Precise PDF export options preventing extra blank pagesSeamless compatibility with Microsoft Excel (.xlsx) filesBuilt-in PDF reader to preview exported files immediatelyFree to use with a lightweight installation
microsoft office alternative - wps office

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'.