Inserting page breaks in the worksheet

Follow these instructions as part of designing a financial statement.

You can insert page breaks into a financial statement design so that the statement is divided the way you want over multiple pages.

Repeat these instructions for other financial statements in the workbook, as needed.

To insert page breaks:

1. Open the worksheet, if needed.
2. On the Design tab, click the Print button. The Print Preview window appears.
3. Click the page forward or backward buttons to view the entire statement and determine where to insert page breaks. 
4. Click the Close button to close the Print Preview window and return to the Design tab.
5. Click a row where you want to insert a page break, and click the Page Break button.
6. Click the Print button to view the results in the Print Preview window.
7. Repeat these instructions for each page, as needed.

See also

Creating footers in the statement

Repeating column headings in the worksheet