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 21, 2018)

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 display 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

Calculating Time Differences between Two Machines

Want to know how much of a time difference there is between your machine and a different machine? This tip provides some ...

Discover More

Keyboard Changes to Unwanted Foreign Language

There you are typing along, minding your own business, when wham! You end up in an entirely different language and you ...

Discover More

Opening Sites in a Browser

You can store all sorts of information in a worksheet, including Web addresses. If you want to open those addresses in a ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

More ExcelTips (ribbon)

Hiding and Unhiding Worksheets

Worksheets are easily accessible in a workbook, but you may not want them to be so open. You can hide worksheets so they ...

Discover More

Condensing Multiple Worksheets Into One

Want a quick way to combine your worksheets? This tip features a simple macro to do the task for you.

Discover More

Alphabetizing Worksheet Tabs

As you get more and more worksheets into a workbook, you'll find yourself moving them around into different sequences. ...

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 8 + 1?

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.