1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Change the Worksheet Tab Color in Excel 2003

Make Indiviual Worksheet Tabs Easier to Identify in Excel 2003

By

Changing the Worksheet Tab Color

Changing the Worksheet Tab Color

© Ted French

To help you find specific information in large spreadsheet files, it is often useful to color code the tabs of worksheets containing related data. Similarly, you can use different colored tabs to differentiate between sheets containing unrelated information.

Related tutorial: Change the Worksheet Tab Color in Excel 2007 / 2010.

To Change the Worksheet Tab Color

  1. Click on the tab(s) of the worksheets you want to re-color. To select more than one tab hold down the CTRL key on the keyboard and click on each tab with the mouse pointer.

  2. Choose Format > Sheet > Tab Color to display the Format Tab Color Palette.

  3. Pick a color.

  4. Click OK.

Results

  1. Changing the tab color for one sheet only :
    • the sheet name is underlined in the selected color.
  2. Changing the tab color for more than one sheet:
    • the active sheet tab is underlined in the selected color.
    • All other sheet tabs display the selected color.

©2014 About.com. All rights reserved.