How to Change the Color of the Worksheet Tabs in Excel

00_lead_image_colored_tabs

By default, inactive worksheet tabs in Excel are gray, and active or selected worksheet tabs are white. If you have a lot of worksheets in your workbook, it may be hard to quickly find a particular sheet.

One way to differentiate worksheets is to assign different colors to the worksheet tabs. We’ll show you how to change a single worksheet tab or multiple worksheet tabs at once.

To change the color of a single worksheet tab, right-click on the tab and move your mouse over the “Tab Color” option. A palette of Theme Colors and Standard Colors displays on the colors submenu. Click on a color to select it, or click on “More Colors” if you want a color you don’t see on the palette.

01_change_color_on_one_tab_using_right_click

You can also use the ribbon to select a color for a tab. Make sure the worksheet tab for which you want to change the color is the active tab. Then, make sure the Home tab is active on the ribbon. Click “Format” in the Cells section, move your mouse over “Tab Color”, and then click a color on the colors submenu.

02_selecting_color_on_ribbon

If you prefer using the keyboard you can press Alt, H, O, T in succession (pressed separately, one after the other–do not hold any of the keys down). Once you press “T”, you’ll see the colors submenu where you can click on a color to choose it, or you can use the arrow keys to move to the color you want and then press Enter.

03_keyboard_shortcut

Once you’ve assigned a color to a tab, it’s displayed in a light gradient of that color when that tab is active.

04_one_red_tab

When the colored worksheet tab is not active, the color on the tab becomes a solid color.

05_solid_red_tab

You can also apply color to multiple worksheet tabs at once, as long as it’s the same color. To change the color of two or more contiguous worksheet tabs, click the first tab you want to select and then press Shift and click on the last tab you want to select. Then, right-click on any of the tabs in the selected group and change the Tab Color as shown earlier.

06_selecting_contiguous_tabs

While the tabs are still selected, they all have a light, gradient shade of the chosen color.

07_contiguous_tabs_red

To deselect a group of selected tabs, click on any tab that’s not selected. If all the tabs are selected, you can right-click on the tabs and select “Ungroup Sheets” from the popup menu.

07a_ungroup_sheets

To select multiple sheets that are not contiguous, click the first tab you want to select then press and hold Ctrl and click on the second tab you want to select. Continue this until all the desired tabs are selected.

08_selecting_non_contiguous_tabs

Then, you can select a color for the selected tabs the same way we described earlier. Again, while the tabs are still selected, they are colored in a light gradient shade of the chosen color.

09_non_contiguous_tabs_red

Active worksheets with colored tabs have the light, gradient shade of the color and non-active colored tabs are solid colored.

10_solid_red_tab_and_light_red_tab

We only used red on the tabs in our example, but you can choose different colors for different tabs, as shown in the image at the beginning of this article.

To return the worksheet tabs to their original gray/white state, select the tabs and then choose “No Color” from the colors submenu under the Tab Color menu option discussed earlier.

Lori Kaufman is a writer who likes to write geeky how-to articles to help make people's lives easier through the use of technology. She loves watching and reading mysteries and is an avid Doctor Who fan.