Why Excel page breaks land in the wrong place in a PDF.

You set the page breaks so that each page ends after a client's last line. You save as PDF. Page 1 now ends three rows earlier, every page after it is off by the same amount, and the last page holds a total on its own.

Excel page breaks land in the wrong place in a PDF because Excel works out where each page ends from settings that can change between the preview and the export. Excel's help page lists them: automatic page breaks come from the paper size, the margin settings, the scale options and the positions of any manual breaks you inserted. The grid you edit has no pages. The breaks you see are the result of that calculation, and the export runs it again.

Why do page breaks change when you save as PDF?

Because the PDF can be laid out against a different page from the one your preview used.

A thread on the spreadsheet maker's own Q&A forum shows it happening. The person asking built schedules in Page Break Preview, with 35 rows on the first page. Saved as PDF, the first page held 32, and an 18 page document came out at 20. They fixed it break by break, every time, and called it a massive inefficiency. A volunteer moderator answered that the output is always scaled, and that Page Break Preview scales it for the default printer. What worked in the end was printing to a PDF printer instead of saving as PDF.

Excel's own help points the same way. Its page on scaling warns that when the paper size in the page setup differs from the paper size in the printer, Excel adjusts the printout to the printer's paper, and the result might not match the preview.

How do you control where Excel puts page breaks?

On the View tab, open Page Break Preview. On Windows, the dashed lines are the breaks Excel added and the solid lines are the ones you added. You can drag a line to move a break, and moving an automatic break turns it into a manual one.

To place a break yourself, select the row that should start the new page, then on the Page Layout tab use Breaks, Insert Page Break. Remove Page Break takes one out. Reset All Page Breaks takes all of yours out and leaves only the automatic ones.

One setting overrides all of that. Excel ignores manual page breaks when you use the Fit to option. The usual fix for cut off columns, fit to one page wide, cancels the breaks you placed. Part 1 covers that setting and what it does to the text. If your breaks need to hold, set the scale with Adjust to instead.

Why does a table split across pages in the wrong place?

Because Excel breaks at the row where the page is full, and the row has no idea what it belongs to.

A client's lines, a group of campaigns, a month and its subtotal: on screen they read as one block. To the pagination they are rows of a certain height. If the page fills two rows before the subtotal, the subtotal starts the next page, alone, under no heading.

For an ordinary range of rows, the tool Excel's help pages offer is the manual break: put one before the group and the group starts a fresh page. It works until the group moves, and in a monthly report it moves every month.

Why does my Excel PDF have blank pages?

Because Excel counts something past your data as content. Its troubleshooting article on blank pages lists the usual causes: cells formatted so their content does not show, such as white text, errors set to print as blank, drawing objects sitting outside the data, and hidden columns that carry manual page breaks.

Formatting can do it too. An empty cell that still carries formatting can add printed pages. To find where Excel thinks the sheet ends, press Ctrl+End. If it lands far below or to the right of your data, select the rows and columns past the data and use Clear All on them. Setting a print area around the data also keeps the rest out of the PDF.

Why do the page breaks need fixing every month?

Because a manual page break is fixed to a row, and next month the rows are different.

Say your table has 38 client lines in September, and the break before the fourth client sits at row 22. In October that client gets two more lines. The break still sits at row 22, which is now in the middle of the client. And if the report starts from a fresh export each month, the new file has no breaks at all.

How does Pressentable decide where a page ends?

Pressentable works out the pages from the report every time it lays the report out, and never saves them. Throw them away, lay the report out again, and you get the same pages back. Load next month's file and it works them out again for the new rows.

A table splits only between rows, never through one. Every page it lands on starts with its header. No page is left holding fewer than two of its rows. The Northwind Cloud recap at the end of this post is a twelve-month table too long for one page: it splits after June, six months on each page, and page 2 opens with the column names.

The last page has its own rule, written after an earlier version of the product got it wrong. Our own January test pack, 42 rows, ended on a page carrying 3 rows under two full pages. Now, when the last piece of a table would fill less than a third of its page, the break moves back and the last two pages come out evenly set. No page is added and no row changes order.

A chart, a row of key figures or a logo is never cut. If it does not fit in the space left, it starts the next page.

You can still start a new page yourself, before any block. It is the one page decision a person makes, and the only one the report stores. A break placed before the very first block is ignored, so it can never print a blank first page.

What should you check before the PDF goes to a client?

Look at the last page. If it holds two or three rows, or a total on its own, the break before it needs moving.

Check that every table that crosses a page starts the new page with its column headings.

Scroll past the last page you expect. A blank page at the end usually means something past the data counts as content.

Compare the page count with last month's. A report that grew from 18 pages to 20 without new content has been paginated differently.

The client reports page shows how a report is laid out when the pages are worked out from it, and the Northwind Cloud growth recap is a live one.

Part 2 of 3 on spreadsheets that become PDFs. Part 1 covers columns cut off at the edge of the page; part 3, the header row and page numbers on every page.