Show Me Microsoft Office 2003

If you want to print a worksheet that is larger than one page, Excel divides it into pages by inserting automatic page breaks . These page breaks are based on paper size, margin settings, and scaling options you set. You can change which rows or columns are printed on the page by inserting horizontal or vertical page breaks . In page break preview, you can view the page breaks and move them by dragging them to a different location on the worksheet.

Insert a Page Break

To insert a horizontal page break, click the row where you want to insert a page break.

To insert a vertical page break, click the column where you want to insert a page break.

Click the Insert menu, and then click Page Break.

Preview and Move a Page Break

Click the View menu, and then click Page Break Preview.

Drag a page break (a thick blue line) to a new location.

When you're done, click the View menu, and then click Normal.