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 View > Page Break Preview
- Point to a page break line
- Click and drag the page break line to a new position
- Click View > Normal to end the page break preview and return to the normal view
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 do not need to be in Page Break Preview in order to insert page breaks, however you may find it easier to work with.
- Select a cell at the start of the column or row where the page break is to be inserted
- Click Insert > Page Break
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
- Select the cell directly below a horizontal page break, or to the right of a vertical page break
- Click Insert > Remove Page Break