Header and Footer Data Codes

Summary: A listing of command codes for Excel headers and footers. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Excel includes a number of codes which you can include in your header and footer. These codes are designed to make including predefined information a bit easier. Some of the codes are available on the Header or Footer dialog boxes (when you click on Custom Header or Custom Footer in the Header/Footer tab of the Page Setup dialog box) by clicking on a button. Others you must enter directly.

Command codes are indicated in Excel headers and footers by typing an ampersand character (&) followed by the command. The following are the data codes you can use:

Code		Meaning
&D		Current date
&T		Current time
&F		Workbook name
&A		Worksheet name (from the worksheet tab)
&P		Current page number
&P+x		Current page number plus x
&P-x		Current page number minus x
&N		Total pages in the workbook
&&		Ampersand character

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2056) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Make Home Buying Less Stressful! Why make home buying harder than it needs to be? Put your mind at ease—discover all the questions you need to ask to make the best buying decision.

Check out Buying a Home Checklist today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Header and Footer Data Codes