How to Change the Worksheet Tab Color

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 2003.

To Change the Tab Color of One Worksheet

For help with this example see the image above.

1. Right click on the tab of the worksheet you want to re-color to open the drop down menu.
   
   
2. Select Tab Color in the menu list to open the color palette.
   
   
3. Pick a color for the worksheet tab. If you don't find a color you like, click on More Colors at the bottom of the color palette to open the Custom Color Palette.

To Change the Tab Color of Multiple Worksheets

Note: All of the selected worksheet tabs will be the same color.

1. To select more than one worksheet tab, hold down the CTRL key on the keyboard and click on each tab with the mouse pointer.
   
   
2. Right click on one of the selected worksheet tabs to open the drop down menu.
   
   
3. Select Tab Color in the menu list to open the color palette.
   
   
4. Pick a color for the worksheet tab. If you don't find a color you like, click on More Colors at the bottom of the color palette to the Custom Color Palette.

Results

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

• excel worksheet tab
• excel formatting