Excel automatically puts in page breaks when your worksheet spans more than one page. However, the page breaks may not be exactly where you want them. In such cases, you can force page breaks.
To force a page break in Excel 2002:
- Select the cell that you want to start on a new page.
- From the Insert menu, click Page Break. A dashed line appears between above the selected you selected in step 1.