Why Excel page breaks move when you save as PDF (and how to pin them)

Short answer: Excel recomputes pagination against the currently active printer’s metrics when it exports, so the page breaks you carefully set in Page Break Preview can land differently in the PDF. Paper size, margins, scaling and the selected printer all feed that calculation, which is why the same workbook can break in different places on two machines. To pin the breaks, fix those inputs before you export: set an explicit paper size and margins, lock the scaling, and pick a stable printer or the “Microsoft Print to PDF” device, then re-check Page Break Preview. If the breaks still drift, the deeper fix is to stop depending on the printer entirely and use a tool that paginates the sheet itself.

Why the breaks move

• Pagination is printer-dependent. Excel asks the active printer driver how much fits on a page. Change the printer, and the usable area, and therefore the breaks, change with it.
• Scaling overrides your manual breaks. If “Fit to” width or height is set, Excel will move or ignore manual breaks to satisfy the scaling.
• Paper-size mismatches shift everything. An A4-versus-Letter difference between your setup and the export target nudges margins and breaks together.
• A stale or oversized used range. Phantom cells below or right of your data extend what Excel thinks it must paginate.

How to pin them

1. In Page Layout, set an explicit paper size and margins rather than leaving defaults.
2. Turn off Scale to Fit if you set manual breaks (scaling and manual breaks fight each other).
3. Select a consistent printer or “Microsoft Print to PDF” so the metrics do not change between exports.
4. Clear stray formatting below your data so the used range matches what you can see, then reset the breaks in Page Break Preview.

The tool-side fix

If the breaks have to be reliable every time, the sturdier answer is to not let the printer decide them. CrazySmartPDF paginates the sheet itself so a row is never split across a page break, independent of the active printer driver, which removes the machine-to-machine drift at its source. On the Windows desktop app it also flags any page that came out blank or clipped so you can review it before sending.

FAQ

Why do the breaks differ on my colleague’s machine? Because their default printer reports a different printable area, so Excel paginates against different metrics. Standardising the printer, paper size and scaling on both machines removes most of the difference.

Does “Microsoft Print to PDF” fix it? It gives you a stable, consistent device to paginate against, which helps. It still renders your page setup as-is, so a wide table that was already clipping will keep clipping; it pins the breaks, it does not re-lay-out the sheet.

Can I stop worrying about the printer altogether? Only by using a tool that computes pagination from the content rather than the driver. CrazySmartPDF does that, keeping rows whole regardless of which printer is selected. It is free to run on your own files; see how it works.