How to Change the Sheet Tab Color in Microsoft Excel

In Microsoft Excel 2002 and later, you can change the color of the worksheet tabs. This color coding can be used for categorizing the data on the sheets or to just spiff up your workbook!

Difficulty: Easy

Instructions

Things You'll Need:

• Microsoft Excel, 2002 or later

1. Open Microsoft Excel and a workbook with more than one worksheet. It can be a new workbook or an existing workbook with multiple work sheets.

2. 
   Right Click Tab

   Right click on the tab that you want to change and a menu with pop-up.

3. 
   Point & Click

   Hover your mouse pointer over “Tab Color” and a menu will pop-out. Click on the color of your choice from the display. If there isn’t a color displaying that you like, you can click on “More Colors” to display the full color palette.

4. 
   Active Tab

   The tab of the active worksheet will appear underlined with the color you chose. When the worksheet is not active, like sheets 2 and 3 in the image at left (click to enlarge), then the chosen color will show as the entire background of the tab.

5. If you want to color multiple sheets the same color, hold down on the CRTL key as you LEFT click each sheet you want to color in one color. Then right click and follow Step 3.

[AutumnLeavz]

on 6/3/2008 This is good info to know. I definitely need all the help I can get when it comes to excel! Thanks!