Page breaks can be used to separate pages for printing. They are inserted automatically when printing, dependent upon the worksheets page setup properties. After printing or print previewing a worksheet they are shown as dashed lines on the page.
Page breaks can be adjusted on the worksheet to better position them. Page breaks can also be inserted and removed.
View and modify page breaks
- Click the Page Break Preview button in the Workbook Views group of the View tab
- Point to a page break line
- Click and drag the page break line to a new position
- Click the Normal button in the Workbook Views group of the View tab to end page break preview
The worksheet is displayed showing the print area with each page labeled. Dashed blue lines indicate automatic page breaks, and solid blue lines indicate manually created page breaks.
The mouse pointer changes to a double headed arrow.
Any automatic page breaks that were adjusted are converted to manually created page breaks.
Moving page breaks to the right or down will automatically scale the print smaller to fit onto the page
Inserting a page break
You need to be in Page Break Preview in order to insert page breaks.
- Right click on the cell at the start of the column or row where the page break is to be inserted
- Select Insert Page Break from the contextual menu
A contextual menu and the Mini Toolbar will be displayed.
The page break will be inserted above or to the left of the selected cell.
If you select a cell in the middle of the worksheet a horizontal and vertical page break will be inserted.
Removing a page break
- Right click on the cell directly below a horizontal page break, or to the right of a vertical page break
- Select Remove Page Break from the contextual menu that appears
Page breaks can also be removed by dragging the page break line off the page.