Sometimes page breaks fall at inconvenient places in your spreadsheet. But you can do more than just adjust your margins. Excel allows you to insert and even move page breaks. I’ll show you two methods for controlling page breaks in your Excel workbooks.
First we’ll cover the old-school method. It’s simple but effective. Just put your cursor on the line that should begin a new page. Select the Page Layout tab on the ribbon. Click the Breaks button and choose Insert Page Break. If your cursor is in column A, the page break will be inserted between the current row and the row above it. If you are in any column other than A, Excel will also insert a vertical page break to the left of the current column. You can remove a page break by positioning your cursor immediately below a horizontal page break or to the right of a vertical page break and choosing Remove Page Break instead of Insert Page Break. The Breaks button also includes an option to reset all page breaks.
The other method takes a more visual approach. Click on the View tab on the ribbon and select the Page Break Preview button. The view will change slightly, allowing you to see only the printable area, and blue dashed lines will appear representing the automatic page breaks. Solid blue lines represent manually inserted or adjusted page breaks. You can drag any of those lines to adjust the page breaks. If you move a page break to put less on a page, the other automatic page breaks will simply shift an equal distance (manual page breaks will not be changed). But if you move a page break to make more print on a page, Excel will automatically scale down the print size as needed to fit everything onto the page. If you want to undo all of your changes the Reset All Page Breaks option from the Breaks button on the Page Layout tab works regardless of which method you used to set the page breaks.
