• Excel Book Excerpt

Excel Organize Your Worksheet Tabs with Color

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Organize Your
Worksheet Tabs with Color

Problem: I have a lot of tabs in a workbook. Can I highlight the frequently used tabs in red?

Strategy: You can right-click a tab and choose Tab Color to assign a color to a worksheet tab.


Figure 1205 Add color to the worksheet tabs.

Gotcha: You can see the tab colors of all but the active sheet. The active sheet appears with a mostly white tab and only a tiny swatch of color.

Additional Details: If you choose Theme Colors for your worksheet tabs, the tab colors will change if you choose a new theme.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel:

privacy policy