Say that you change the margins for the page, using Page Layout, Margins. The location for the next automatic page break is now shown at row 55 instead of row 47.Īutomatic page breaks will move around.
I am not sure the difference will even show up in the book or e-book.īecause you've added a manual page break after row 8, Excel will automatically calculate that it can fit rows 9 through 54 on page 2. Here is a zoomed-in view of the different dashes used for each break.
Excel will draw in a dotted line above the cell pointer to indicate that there is a page break after row 8. You position the cell pointer in column A on the first row for a new customer and then select Page Layout, Breaks, Insert Page Break. You can add a manual page break to any row.