Row-atomic page breaks: why a spreadsheet row should never split across pages

Short answer: Excel decides page breaks by height — it fills a page top to bottom and cuts wherever the margin lands. If a tall row happens to straddle that line, Excel slices it: the top of the row on one page, the rest on the next. Row-atomic pagination is the opposite rule — treat every row as an indivisible unit, so a row that won’t fit on the current page moves to the next page whole. It’s a small idea that quietly prevents a whole class of embarrassing PDFs.

Why a split row is worse than it looks

A sliced row isn’t just ugly — it’s misleading. Picture an account row where the label “Marketing — Q3 accrual” sits at the bottom of page 2 and its figure 48,450 sits at the top of page 3. Anyone scanning the pack can misread which number belongs to which line. In a financial statement or an invoice, that’s not a cosmetic bug; it’s a correctness risk. The same goes for a header stranded at the foot of a page with its data overleaf.

The manual fix, and why it doesn’t hold

You can force this by hand in Excel: open View → Page Break Preview and insert a manual page break above any row that must stay whole (Page Layout → Breaks → Insert Page Break). Add Print Titles → Rows to repeat at top so headers reappear on every page.

The problem is that manual breaks are brittle. Insert or delete a few rows above them and every break below is now in the wrong place — so you’re back in Page Break Preview redoing the whole thing on every revision. It’s the definition of work you shouldn’t have to repeat. The step-by-step is in how to stop Excel splitting rows across pages.

What row-atomic does instead

CrazySmartPDF builds row-atomic pagination into the renderer, so it isn’t something you set up per file. Every cell — and therefore every whole row — is rendered “show entire”: a row that won’t fit in the space left on the page moves to the next page intact. No orphaned half-rows, no lone digit stranded at the top of a page. The header rows it detects repeat automatically at the top of every page, so a long table never loses its column titles. This is exactly what keeps a wide financial statement or a multi-sheet board pack readable when it runs to many pages.

The honest limit

There’s one genuine constraint, and it’s physics: a single row taller than an entire page still has to break somewhere — nothing can keep it whole. In practice that’s rare, partly because long cell text is capped at a few lines so one row can’t balloon past a full page. And like the rest of the engine, this runs through your installed Excel on Windows (2016+); it reads your workbook and never modifies it.

CrazySmartPDF is free to use. The home page shows the layout pass in action, row-atomic breaks included.