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

Got the Time? Understanding the ins and outs of working with times and dates can be confusing. Remove the confusion--ExcelTips: Times and Dates is an invaluable resource for learning how best to work with times and dates.

Check out ExcelTips: Times and Dates today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Header and Footer Data Codes