Right-Click the Sheet Tab to Change the Tab Color
When you can’t find a worksheet because your Excel workbook contains too many worksheets, color code the sheet tabs. Here’s a quick way to change the color of a tab in Excel:
Use Hot Keys to Change a Sheet Tab Color
When you use keyboard hotkeys to change the tab color, this set of keystrokes activates the ribbon commands. Once the last key in the sequence – the T – is pressed and released, a color palette opens. To change the sheet tab color using the keyboard:
Change the Tab Color of Multiple Worksheets
To change the sheet tab color for multiple worksheets, first select the worksheets that will be the same color. Then choose a color.
Ctrl+PgDn: move to the sheet on the right.Ctrl+PgUp: move to the sheet on the left.
The current tab color is highlighted (surrounded by an orange border). If you haven’t previously changed the tab color, white is selected. The selected sheets can be:
Contiguous: Sheets that are next to each other such as Sheet1, Sheet2, and Sheet3. Non-contiguous: Sheets that are not next to each other such as Sheet4 and Sheet6.
Select Contiguous Worksheets to Change Sheet Tab Color
When you want several sheets in a row to use the same tab color, use the Shift key to select the group.
Non-Contiguous Worksheets and Sheet Tab Color
When you want several worksheets to have the same tab color, but those sheets are not next to each other, use the Ctrl key to choose the sheets.
Tab Color Rules
When you change sheet tab colors, the rules Excel follows in displaying the tab colors are:
Changing the tab color for one worksheet: The worksheet name is underlined in the selected color.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.
