bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Page Setup > Page Numbers > Adding Page Numbers

Adding Page Numbers

Summary: How to add page numbers to a custom header or footer in an Excel worksheet. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

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.

Tip #2637 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


Make Home Buying Less Stressful! Why face the annual problems associated with Christmas debt? Learn how to avoid that debt and conquer your financial challenges.
 
Check out Buying a Home Checklist today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)