Excel.Tips.Net ExcelTips (Menu Interface)

Using Color in Headers and Footers

When creating headers and footers for your worksheets, you can modify many attributes used by Excel. When you design a custom header or footer you can click the A tool in the Header or Footer dialog box to select a font or to change other attributes of the font (size, style, etc.).

If you are using Excel 97 through Excel 2003, one thing you cannot change is the color used for the text. Early versions of Excel allowed you to modify header and footer colors, but the capability was removed beginning in Excel 4.0.

If you can't change the color, the only thing you can do is try a workaround. If you are using Excel 97 or Excel 2000, you can simply create your "header" in the first row of your worksheet, and then repeat that row at the top of each printed page. (There is no way to repeat a row at the bottom of a page, so you'd be out of luck for color footers.)

If you are using Excel 2002 or Excel 2003, you can create a color graphic, and then place that graphic into the header or footer. This is often done when you need color in logos and other graphic elements, and you need them to repeat on multiple pages.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3251) applies to Microsoft Excel 97, 2000, 2002, and 2003.

Related Tips:

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA 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 4+5 (To prevent automated submissions and spam.)
          Commenting Terms

Comments for this tip:

Raja    28 Jul 2015, 12:47
How to make words with highlight in Header?
Darlene    30 Mar 2013, 11:47
I LOVE your newsletter. TY for publishing it. I have become an Excel freak. Well, honestly, I am a genealogist but use Excel to fine tune and analyze my genealogy information.

I am attempting to standardize my worksheets. I want to create and document my standardized sheets so that I always work them the same way. Is there a standard for headers & footers ie placing file names & tab names in headers & footers?

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 © 2015 Sharon Parq Associates, Inc.