Printing

Basically you should be in row 1 or column A when creating page breaks.

Go to View page break preview to view the page breaks in your spreadsheet they will be displayed by dashed blue lines or a thick blue line. Dashed blue lines are created by Excel automatically whilst the thick blues lines are manually inserted page breaks.

To resize a page break in page break preview drag the blue lines to where you want the page break to be. Note dragging a page break off the page in two page document will resize it to one page.

To insert a page break make sure you are in row 1 or column A then select Insert - Page Break from the menu.