Microsoft Excel XP:  Recolor Worksheet Tabs

There is a wonderful new feature in Excel XP that has not been there before. You can now color-code your worksheet tabs.

1. Select the sheet(s) you want to color.
2. On the Format menu, point to Sheet, and then click Tab Color. You can also right-click on the sheet tab and then click Tab Color.
3. Click on the color you want and click OK.

Now whenever you select a color-coded worksheet, the sheet tab name will be underlined in color. When the sheet tab is not selected, it will be displayed with the background color you chose.

If you have any questions regarding this tip or need help implementing it in your own projects, contact Ranelle Maltas, Application Support Associate, at 472-0585 or e-mail at rmaltas2@unl.edu.