"How To Excel" Mini-Tutorials|
"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
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
- From the View menu select 'Header and Footer...'
- 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.
- If you selected a built-in footer, you will need to click the
'Custom Footer' button.
- To change the font of your footer, select the text to be
- Click on the Font icon (the one with the letter A on its
- Select the desired font formatting.
- Click OK to close the Footer dialog box.
- Click OK to close the Page Setup dialog box.
- Click File, Print Preview to check out the changes you just
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)