Excel to PDF Blank Extra Pages: Find and Remove the Cause

Last updated

Excel to PDF blank extra pages come from the workbook itself, since the converter prints each sheet with the print areas and page setup saved in the file.

Microsoft explains that formatting left behind in empty cells can push the last cell of a sheet past the range that actually holds data. Locate and reset the last cell (Microsoft Support)

Excel To PDF

Why Excel to PDF Adds Blank Extra Pages

Excel to PDF hands the workbook to LibreOffice with no page range, so every page a sheet prints with something on it ends up in the PDF.

In our October 2026 test, formatting alone didn't add a page. A 20-row sheet with fills and borders on empty cells down to row 5,000 still gave 1 page, the same PDF as the clean sheet.

One stray x in cell AB300 of the clean sheet gave 2 pages: the data, then a page with nothing but that x.

Put the two together and we got 7 pages, because the stray value stretched the printed area over the formatted cells: pages 2 to 6 held only empty bordered cells, and page 7 just the x.

Empty Sheets, Pictures and Paper Size

Empty sheets don't add a page. In our October 2026 test, a workbook with a 20-row data sheet, an empty sheet and a sheet of resized but empty rows gave 1 page with one bookmark.

A picture far from the data does add one: with data in A1:C20 and a picture anchored at M60, the PDF had 2 pages, and the second held only the picture.

Move charts and pictures next to the data, or delete the ones sitting far below or beside it.

Paper size comes from the workbook, not from a printer. A sheet set to Legal came out as one 8.5 by 14 inch page of 612 by 1008 points.

Find the Stray Cell First

Press Ctrl+End in each sheet to jump to the last cell Excel counts as used.

Look for spaces, empty strings or formulas that return nothing, far below or to the right of your data.

Delete that stray content first, then clear the formatting around it.

Clean Up the Workbook Before You Convert

Select the empty rows below your data, right-click and choose Delete to get rid of them completely.

Do the same for the empty columns to the right of the data.

Remove leftover formats there with Home, Clear, Clear All, then save the workbook.

Once you've cleaned up, saved and reopened the workbook, the last cell of the data should be the last cell on the worksheet. Locate and reset the last cell (Microsoft Support)

Excel to PDF with an XLS workbook queued after removing the cause of blank extra pages

Limit the Output With a Print Area

Set a print area around the real data so nothing outside it reaches the PDF.

LibreOffice doesn't print or export cells that sit outside a defined print range. Using print ranges (LibreOffice Help)

Comments and Manual Page Breaks

In our test, an XLSX with a comment and Excel's Comments setting At end of sheet gave 1 page, and the comment text wasn't in the PDF.

Remove manual page breaks with Page Layout, Breaks, Reset All Page Breaks.

Continue with Word to PDF Fonts and Formatting Changed: Causes and Fixes or Word to PDF Hyperlinks and Tracked Changes: What the PDF Keeps.

Frequently Asked Questions about Excel to PDF Blank Extra Pages: Find and Remove the Cause

Why does my PDF have blank pages at the end?

Press Ctrl+End to find the cell that stretches the sheet, then delete the rows and columns beyond your data.

Does Excel to PDF remove blank pages for me?

Only pages with nothing on them. A page that draws no text, line or shape gets dropped, and every other page stays as the workbook sets it.

Will a print area stop the blank pages?

Set one around your data on each sheet, save the workbook and upload it again.

Can I delete the blank pages from the PDF instead?

Remove them afterwards with Remove PDF Pages if the workbook stays locked.

Does an empty worksheet become a blank page?

No. In our test, an empty sheet and a sheet with only resized rows didn't add any page to the PDF.