Adding Page Numbers

If you are creating spreadsheets that are more than a page or two in length, you will probably want to include page numbers so you can keep your pages in order when you make a printout. Excel supports automatic numbering of pages in your spreadsheet, and you can control the type of page number, the starting number, and the placement of the page number. To add page numbers, follow these steps:

1. Since page numbers are placed in headers or footers, select Page Setup from the File menu. This displays the Page Setup dialog box.
2. Make sure the Header/Footer tab is selected. (Click here to see a related figure.)
3. Click on either Custom Header or Custom Footer, depending on where you want the page number to appear. This displays either the Header or Footer dialog box. (Click here to see a related figure.)
4. Position the insertion point in the Left, Center, or Right box, depending on where in the header or footer you want the page number placed.
5. Click on the page number tool (it looks like a piece of paper with a number sign in the center of it). This places the characters &[Page] at the insertion point. This is where the page number will be located.
6. Click on OK to close the Header or Footer dialog box.
7. Click on OK to close the Page Setup dialog box.