Changing Worksheet Tab Colors

Excel XP allows you to change the color of worksheet tabs, so that you can color-code your workbooks. To add a color to a tab, follow the instructions below.
  1. Right-click on the tab to which you want to add color.
  2. A submenu will appear.
  3. Choose the option Tab Color.
  4. The Format Tab Color dialog will appear.

  5. Click on the desired color.
  6. Click on the OK button.
  7. The worksheet will appear to have a colored line under its name.

  8. Click on a different worksheet to view the full effect.

Note: To remove the tab color, select the No Color option from the Format Tab Color dialog.

Click HERE to return to the Table of Contents.