Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Colors and Fonts for Worksheet Tabs.

Colors and Fonts for Worksheet Tabs

by Allen Wyatt
(last updated May 31, 2014)

4

Excel is quite configurable in how information appears on your screen. At some time you may want to change the appearance of the worksheet tabs at the bottom of your workbook. Unfortunately, Excel allows very little customization of the way worksheet tabs are presented.

If you want to change the font used in a worksheet tab, you need to change the fonts used by Windows (not Excel) to displays information. You can use the Windows Control Panel to modify the appearance of information within your system. Understand, however, that such changes affect all programs running on your system, not just Excel.

If you want to change the color used to display a worksheet tab, you can follow these steps:

  1. Right-click on the worksheet tab you want to change. Excel displays a Context menu.
  2. Choose Tab Color from the Context menu. Excel displays a palette of available colors.
  3. Select a color to use for the tab.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9702) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Colors and Fonts for Worksheet Tabs.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Resolving Revisions

You've reviewed the changes that were made to your workbook using the Highlight Changes tool. Now you need to remove the ...

Discover More

Counting Filtered Rows

The filtering capabilities of Excel are indispensable when working with large sets of data. When you create a filtered list, ...

Discover More

Returning a Worksheet Name

Need to know the name of the current worksheet? You can use the CELL function as the basis for finding this information and ...

Discover More

Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!

More ExcelTips (ribbon)

Jumping to a Specific Worksheet

Want to make fast work of moving from one worksheet to another? Here's how to do the task when you have a lot of worksheets ...

Discover More

Finding a Worksheet with a Specific Value in a Specific Cell

If you have a lot of worksheets in workbook, finding the exact one you want can be a bit tricky. This tip looks at various ...

Discover More

Identifying the Last Cell Changed in a Worksheet

When someone changes a cell in a worksheet, Excel normally goes along its merry way of keeping everything up to date. It does ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is nine more than 8?

2014-06-03 07:22:24

Bryan

Isn't feeling sorry for someone acting superior to them?

At any rate, this tip IS trivial, even if you've never seen the information within it before. It's two clicks (three if you like to click on the fly-out menus). What would take this tip from trivial to informative is a couple of screen shots showing what the whole procedure actually looks like.


2014-06-03 03:47:37

Chris McGee

I agree with you Tony.I too did not know how to change the tab colour.
I feel sorry for people who feel they have to prove their superiority. It is sad that they have nothing better to do than look for things to sneer at.


2014-06-02 03:12:00

Tony Davis

Whilst I agree re changing the font setting in windows is overkill (to me), I disagree with your comment on the triviality of any tip.

I consider myself a fairly experienced user of Excel but there are things I don't know - changing the colour of the tab was one of them.

Just because you know something and/or consider it trivial doesn't mean the rest of the world agrees.


2014-05-31 19:43:46

Christopher Cain

Changing the colour of a tab is a bit obvious and trivial to actually be a tip!

I can't imagine anyone would think changing the font used by windows by changing the font setting in the windows control panel was worth all the trouble just to change the font used in an Excel Tab.


This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.