Select the cell whose upper left corner is where you want the page break to appear.ĮXAMPLE: If you want the page break to appear between columns L and M, and between rows 8 and 9, select the the cell M9. Do not create more custom page breaks than you require. WARNING: Excel will print every page designated by a custom page break, including blank pages. NOTE: To change how your Excel sheet is viewed, from the View command tab select either Page Layout or Normal.
When a document is printed, information on each side of the break will appear on different pages. If you are viewing your Excel sheet in Normal form, then the dotted lines that appear represent the margins of the printer paper. Therefore, all page breaks and margins will appear on the screen. In Page Layout form, your Excel sheets will appear as they would be printed. Your Excel sheet will likely be displayed in Page Layout form.
Page breaks determine the boundaries of printable information. For more printing information, refer to Printing Basics ( Win | Mac) and Chart Extras: Printing Chart and Worksheet Data. There are several ways to customize your printing area, which can help create the exact printouts you desire. This article is based on legacy software. (Archives) Microsoft Excel 2007: Using Printing Options Mac
