Microsoft Office Tutorials and References
In Depth Information
For lengthy printouts, you probably want to add page numbers to help keep the pages in order.
This tip describes your page numbering options.
Applying basic page numbering
To add page numbering, follow these steps:
1. Choose View
Page Layout, to switch to Page Layout view.
Notice that each page has a header at the top and a footer at the bottom. Each header
and footer is divided into three sections: left, center, and right.
2. Click the header or footer area where you want the page number to appear.
3. Choose Header & Footer Tools
Excel inserts a code that represents the page number.
4. Click any cell in the worksheet to see the actual page numbers.
In Step 3, the code that Excel adds simply inserts a number. You can add text to the page
numbering code. For example, if you want your page numbers to read Page 3, type Page (followed
by a space) before the code. This type of header or footer entry looks like this:
You might prefer to include the total number of pages so that the page numbering reads like this:
Page 3 of 20. In Step 3, choose Header & Footer Tools
Number of Pages to insert the
code. You also need to enter the word of. The complete code looks like this:
Page &[Page] of &[Pages]
Changing the starting page number
If your printout will be part of a larger report, you might want to begin page numbering with a
number other than 1. To do so, follow these steps:
1. Choose File
Print, and Excel displays the Print settings in Backstage View.
2. Click the Page Setup link to display the Page Setup dialog box.