Controlling page breaks in Excel-to-PDF exports

Excel page break basics

Excel inserts page breaks automatically based on row height and the page size. To override: View → Page Break Preview. Drag the blue lines to manually set where pages split. Insert hard page breaks via Page Layout → Breaks → Insert Page Break (it inserts above the selected row).

Common page-break problems and fixes

• Break mid-record: insert a hard break BEFORE each major section or record group.
• Header on page 1 only: Page Layout → Print Titles → "Rows to repeat at top".
• Section title orphaned: use the "Keep with next" workaround by inserting a hard break before the section, never after.
• Page break in the middle of a long text cell: that's a row-height issue, set explicit row heights and use word wrap.

When automated breaks are smarter

fitforpdf decides page breaks based on record boundaries, not arbitrary row counts. Multi-line cells stay together. Section titles stay attached to their content. Footer rows include "Rows 1–50 of 200 · Page 1 / 4" so the reader always knows what they're looking at.