Blog · 8 articles

Blog

Practical, honest guides to getting clean PDFs out of Excel — the page-setup traps, how to fix them by hand, and where an automatic layout-and-self-check pass earns its keep.

The same seven invoice rows from both PDFs at true paper scale. Excel's export stops after the Region column; CrazySmartPDF's carries the same rows through Balance, Days Past Due and Status. Start here Print, not layout: the real reason Excel's Save as PDF breaks your spreadsheets Excel's Save as PDF is a print of your page setup, not a layout engine — one architectural fact that explains every cut-off column, split row and shrunk export. Here's the mental model, and what a real layout pass does instead. July 10, 2026 Read it

When the page setup drops something

A print area is the most useful page-setup control in Excel and the easiest one to leave stale. Both of these are about the same risk: an export that looks finished and is quietly short a column.

How to set up an Excel print area for clean PDFs A print area tells Excel exactly which block to put on the page. Here's how to set, check, and clear one — plus the trap: everything outside it disappears from the PDF, silently. July 10, 2026 Print-area honesty: why silently dropped data is the dangerous kind A clipped column you can see is annoying. A column that silently vanished — cut out by a stale print area — is dangerous, because nobody knows to look for it. Here's why CrazySmartPDF renders your whole sheet instead of trusting a boxed-in block. July 10, 2026
Page 19 of Excel's own PDF export: a full page of Discount, Tax, Invoice Total, Paid to Date, Balance, Days Past Due and Status figures, with no invoice number, client or date anywhere on the page.
Real output · Excel · page 19 of 24 This is what “it exported fine” can look like. Excel's own Save as PDF put this 23-column sheet onto 24 portrait pages in four column groups. Page 1 carried six columns and no money at all. Every figure above landed here, on page 19 — eighteen pages from the invoice numbers they belong to, with nothing on the page tying a balance to a client. Nothing was deleted and nothing looked broken, which is exactly the problem. Page 19 of the real PDF, rasterised at 200 dpi. Sample workbook — every company, invoice number and figure in it was invented. No customer data.

When a row gets cut in half

Excel paginates by height, so a tall row can be sliced across a page break — the label on one page, the number on the next.

Row-atomic page breaks: why a spreadsheet row should never split across pages Excel paginates by height, so a tall row gets sliced across a page break — label on one page, number on the next. Here's why that's dangerous and what row-atomic pagination does instead. July 10, 2026

When it is not one file

Month-end is a folder, not a workbook, and Save as PDF is a one-file-at-a-time control.

How to batch-render a month-end reporting pack to PDF Month-end means a stack of workbooks, exported one at a time by hand. Here's how to render a whole folder to PDF in one pass — with a self-check — instead of babysitting Save as PDF. July 10, 2026

More articles

The 60-second check before any client-facing spreadsheet PDF goes out Five things to look at before a spreadsheet PDF leaves the building: the last column, split rows, readable text, stray blank pages, and anything that sat outside the print area. July 21, 2026 Where your spreadsheet actually goes when you use an online converter Upload converters run your file through a server-side render and delete it on a timer. That window — not malice — is what a confidentiality policy has to reckon with. Including ours, stated plainly. July 21, 2026 Why online Excel-to-PDF converters cannot fix your layout An upload converter's job is to reproduce your file faithfully — including faithfully reproducing the broken page setup you sent it. Fixing layout means re-computing it, which is a different kind of engine. July 21, 2026

Try it on the file the article is about

The browser converter takes one workbook and hands back the PDF. It is free, there is no signup, and your file is deleted after the conversion. The Windows desktop app adds whole-folder batch and needs Excel 2016 or newer.

Convert free