Topic: Headers and Footers

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Adding a File Path and Filename Do you need to add a files’ path and name to your workbook? There are a couple of ways you can go about adding the information, either to an existing cell or to a header/footer. This tip explains all the approaches you can use. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Adding Ampersands in Headers and Footers Place an ampersand into the text of a page header or footer, and you might be surprised to see it missing in your printout. This is due to the way in which Excel interprets the ampersand. Here’s how to get around the problem. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Ampersands in Headers and Footers If you need an ampersand (&) to appear in a header or footer, you may be surprised the first time you type one that it disappears when the header or footer is printed. The trick is to actually use two ampersands, for reasons explained in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Changing Section Headers Excel doesn't provide a very easy way to vary headers or footers during a printout. This tip explains how you can use a macro to do your printing and make the changes on the fly. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Creating a Footer Adding a predefined or custom footer to an Excel worksheet. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Creating a Header Adding a predefined or custom header to an Excel worksheet. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Date Last Edited When adding headers or footers to your worksheets, you may want to include the date that the workbook was last edited. Excel doesn’t provide such information, but you can create your own date. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Default Headers and Footers Changing the look of default headers and footers for your Excel workbooks. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Deleting a Footer Each new Excel worksheet contains a page footer, by default. Follow this tip to get rid of the footers you don't really need. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Deleting a Header Each new Excel worksheet contains a page header, by default. Follow this tip to get rid of headers you don't need. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Dynamic Headers and Footers Do you want to change the headers and footers that appear on different pages of your printout? Here’s how you can get just what you want. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Full Path Names in Headers or Footers Using a macro to add the full path name into a header or footer in an Excel worksheet. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Graphics in Headers or Footers A few workarounds for getting a graphic in an Excel header or footer. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Header and Footer Background Color Want to add some color to the printing of your page headers and footers? Your options are limited, as disclosed in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Header and Footer Data Codes A listing of command codes for Excel headers and footers. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Header and Footer Formatting Codes Formatting codes to use in Excel headers and footers. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Inserting the Saved Date In a Header or Footer Using a macro to set the date the workbook is saved in the header or footer. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Keep Your Headings in View How to keep your heading visible while working on the lower rows of the Excel spreadsheet. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Last Saved Date in a Footer It is sometimes helpful to have the page footer of your worksheet contain the date that the workbook was last saved. Unfortunately, Excel doesn’t include a way to add this information. You can, however, add the information with the macros discussed in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Leading Zeros in Page Numbers Page numbers in Excel printouts are typically simple counters, without much chance for embellishment. If you want to add leading zeros to your page numbers, the best solution is to use a macro to do your printing. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Moving Part of a Footer Down a Line When creating a footer for a printout, it is possible for parts of the footer to overwrite other parts. This tip explains how you can use a two-line footer to get around such a problem. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Multiple Line Headers and Footers Using a macro code to set up a multi line header or footer. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Positioning Headers and Footers Excel allows you to control where a header and footer appear on each page of a worksheet. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Printing a Multi-Line Footer Add a footer to your document and you may want to make it span more than a single line. This can be easy to do, provided you remember how to “break” the lines. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Putting a Different Date in a Header Today’s date is easy to add to a header, but what if you want to add a date that is adjusted in some manner? Adding yesterday’s date or tomorrow’s date, for instance, is easy if you use the macro provided in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Putting a Graphic in a Header or Footer Beginning with Excel 2002, Microsoft made it much easier to put a graphic in a worksheet header or footer. Here’s how to do it. Microsoft Excel versions: 2002 | 2003 | 2007

Putting Headers and Footers On Multiple Worksheets Do you need to put the same header or footer on a range of worksheets in the same workbook? It’s easier to do than you think, following the technique in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Putting Spreadsheet Names in Headers or Footers Adding the spreadsheet name into a custom header or footer. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Recognizing a Header Row when Sorting Excel provides a couple of ways you can sort the information in a worksheet. Before sorting, it pays to know whether Excel will recognize your header row properly or not. This tip explains how you can figure out this critical information. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Selective Headers and Footers Excel’s tools for creating headers and footers aren’t that great, which means you might not be able to control the headers and footers like you may need to. This tip explains how you can use a macro to selectively print headers or footers on only some of the pages of your worksheet. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Specifying Date Formats in Headers Dates in headers and footers are formatted using the same pattern used in Windows for the system date. If you need to use a different format, you’ll appreciate the information in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Turning Headers On and Off By default, Excel displays “headers” for a worksheet that consist of the column letters (the column headers) and the row numbers (the row headers). You can turn these headers off, if you desire, by making the easy configuration change to Excel that is described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Using a Different Footer on Secondary Pages When printing a worksheet, you may want to have the footer different on the first page of your document than it is on subsequent pages. Here’s a couple of ways you can get the desired changes. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Using Color in Headers and Footers Applying color to the text in your headers and footers is a bit of a dream in some versions of Excel. Here’s an overview of where color can be used and how you can get around some version limitations. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Tips, Tricks, and Answers

Fast Answers!

Helpful Links

Great Info!

RSS Feeds