Color-Coding Worksheet Tabs in Excel

By Beth Sunny
Posted Friday, December 3, 2004

In Excel 2002, you can color code worksheet tabs to make them easier to recognize. Here's how...

You can color code worksheet tabs to make them easier to recognize. Tabs for inactive sheets will have a solid background in the chosen color. The tab for the active sheet is underlined in the chosen color. There are 56 colors to choose from.

1. Select the tab(s) for the worksheets you want to color.

2. Right-click on one of the selected tabs and choose Tab Color from the shortcut menu.

3. Select a color and then click the OK button.

An example of color-coded worksheets is shown below.

About the Author
Beth Sunny is a writer, publisher, and computer trainer. She owns Software Training Resources (STR), a courseware company known for their "QuickSteps to Learning" training manuals. STR launched an exciting web site in January of 2001. The web site is specifically for the Computer Training Industry - (http://www.sharpertraining.com). The site offers a place for individuals in the Computer Training Industry a place to advertise their business, correspond with others in the industry, find training products, and discover software tips and read great articles relating to computer training. Visit the site today! (http://www.sharpertraining.com)