How to catch blank or clipped pages in an Excel-to-PDF export

Short answer: the only reliable way is to actually look at the finished PDF, page by page, because Excel won’t warn you about a blank page or a clipped edge. You can do that by eye, or use a tool that rasterises its own output and flags the suspect pages for you. CrazySmartPDF’s self-check does the second — and it’s important that it flags, it doesn’t fix.

Doing it by hand

• Open the PDF and page through at 100%. Watch for two things: pages that are near-empty, and content that runs right up against the right edge (a likely clip).
• Track down phantom blank pages in Excel: press Ctrl+End to jump to the true last cell of the sheet. If it lands far below or to the right of your data, a stray cell (an old value, a leftover fill) has inflated the print range — that’s what’s adding blank pages. Delete those empty rows/columns, save, and re-export.

The honest catch: eyeballing every page of every file works for one workbook and falls apart across a folder of them. It’s exactly the boring check people skip, which is how a blank page ends up in front of a client.

How CrazySmartPDF handles it

After it renders, it proofreads its own output:

• It rasterises every page (via PDFium) and runs two detectors — one flags near-blank or orphan pages (almost no ink, or ink crammed into a thin band), the other flags pages where content touches the right edge (a suspected clip).
• Hits go into a health report: “page 3 near-blank — please check,” “page 5 right edge may be clipped — please check.” It’s a proofreading pass you’d never get from “Save as PDF.”

The honest caveats — read this one

This is deliberately a minimal, two-detector slice, and it flags — it does not auto-fix or “heal” anything. The detectors are heuristics (they work off thresholds), so they can miss a subtle case or flag a page that’s legitimately sparse. Their job is to point a human at the pages worth checking, not to certify that the PDF is perfect. It runs on Windows and needs Excel installed (2016+), like the rest of the engine.