How to Insert Page Breaks in Microsoft Excel 2003

Many people use advanced spreadsheet software applications, like Excel, to create detailed financial budgets for both work and home use. The many features currently offered in the latest versions of this software enable the end user to create fancy looking spreadsheets. Sheets that can even be printed on multiple pages thanks to features like the page break.

Things You'll Need

• Microsoft Excel 2003

Instructions

1. Select the area where you wish to insert page breaks. To do this you will need to left-click on the area of the spreadsheet where you would like to insert a page break.

2. Insert the desired page break. Scroll to the “Insert” tab on the command bar and select “Page Break” to insert a page break.

3. Check “Print Preview” to see and edit page breaks. Scroll the “File” tab on the command bar and select “Print Preview” which will show you where your page breaks occur and how they will affect the printed spreadsheet. To see page breaks, left-click on the “Page Breaks Preview” and it will show you where your page breaks are.

4. Adjust page breaks as necessary. You can adjust the page breaks in the page breaks print preview menu simply by left-clicking on the corners and holding while dragging the page breaks where desired.

Tips & Warnings

• Page breaks are great for separating portions of spreadsheets to print on different pages.

• A page break will make any information located below where the page break is inserted print on a separate page.