"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

Change The Footer (or Header) Font

I use footers in almost all of my worksheets. In the footer I include the sheet name, filename, my name, time and date. I've found this practice very useful in helping me later on in identifying which workbook produced the printed report and if the printed report is the latest version. Also, many of my reports are distributed to other people in our company and the readers of the report can quickly see who originated it and when it was produced.

Also, I like to keep the text of my footers very small so that they don't stand out but can be easily read if the reader of the report needs that information (see last line of this tip).

Many people don't realize that you can change the font of your headers and footers. Here's what to do. (Note that the following instructions talk about footers but they apply equally to headers.)

  1. From the View menu select 'Header and Footer...'
  2. If you worksheet doesn't already have a footer, select one from the dropdown list of built in footers or click the Custom Footer button and create one of your own.
  3. If you selected a built-in footer, you will need to click the 'Custom Footer' button.
  4. To change the font of your footer, select the text to be formatted.
  5. Click on the Font icon (the one with the letter A on its face).
  6. Select the desired font formatting.
  7. Click OK to close the Footer dialog box.
  8. Click OK to close the Page Setup dialog box.
  9. Click File, Print Preview to check out the changes you just made.

Some Additional Notes On Headers and Footers:

  • You can apply different formatting to different parts of the footer text by selecting only a part of the text.
  • You are not limited to the font sizes listed in the Font dialog box. Just type whichever size you want in the Size box.

Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.