Excel.Tips.Net ExcelTips (Menu Interface)

Header and Footer Data Codes

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 97, 2000, 2002, and 2003.

Related Tips:

Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!


Leave your own comment:

  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*What is 5+3 (To prevent automated submissions and spam.)
           Commenting Terms

Comments for this tip:

Jordan    03 Sep 2015, 00:38
I need to a different date than the current one. Specifically, tomorrow's date, or +1. Is this possible in the header?
Peter J Moran    03 Mar 2013, 00:11
Hi Jim,
Check this tip:
Creating Default Formatting for Workbooks and Worksheets
set up your footers as required and follow the tip. All your workbooks will now have a standard footer.
Jim Carroll    02 Mar 2013, 08:59
To me, the filename and path are at least as important as date, time, worksheet name, etc. At my age, it's hard to remember what folder contains last year's revenue budget numbers and the like. Is it possible to include filename and path in the header or footer as it is in Word?

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.