3 Ways to Change Worksheet Tab Colors in Excel

01
of 01

Change Worksheet Tab Colors Using Keyboard Keys or the Mouse

Change Worksheet Tab Colors in Excel using Keyboard Keys or the Mouse
Change Worksheet Tab Colors in Excel using Keyboard Keys or the Mouse. © Ted French

To help you find specific information in large spreadsheet files, it is often useful to color code the sheet tabs of individual worksheet containing related data - such as sheets one and three in the image above.

Similarly, you can use different colored tabs to differentiate between sheets containing unrelated information.

Another option is to create a system of tab colors that provide quick visual clues as to the stage of completeness for projects - such as green for ongoing, and red for finished.

Changing the Tab Color of a Single Worksheet

Below are listed three options for changing the sheet tab color of a single worksheet in a workbook.

The options are:

  • Using keyboard keys;
  • Right clicking on the sheet tab - probably the easiest method;
  • Using the format tabs option on the ribbon.

Option 1 - Using Keyboard Hot Keys:

Note: The Alt key in the sequence below does not have to be held down while the other keys are pressed, as with some keyboard shortcuts. Each key is pressed and released in succession.

What this set of keystrokes does is activate the ribbon commands. Once the last key in the sequence - the T - is pressed and released, the color palette for changing the sheet tab color is opened.

1. Click on a worksheet tab to make it the active sheet - or use the following keyboard shortcuts to select the desired worksheet:

Ctrl + PgDn - move to the sheet on the right
Ctrl + PgUp - move to the sheet on the left

2. Press and release in sequence the following key combination to open the color palette located under the Format option on the Home tab of the ribbon:

Alt + H + O + T

3. By default, the color square of the current tab color is highlighted (surrounded by an orange border). If the tab color has not previously been changed this will be white. Click with the mouse pointer or use the arrow keys on the keyboard to move the highlight to the desired color in the palette;

4. If using the arrow keys, press the Enter key on the keyboard to complete the color change;

5. To see more colors, press the M key on the keyboard to open the custom color palette.

Option 2 - Right Click the Sheet Tab:

1. Right click on the tab of the worksheet you want to re-color to make it the active sheet and to open the context menu;

2. Select Tab Color in the menu list to open the color palette;

3. Click on a color to select it;

4. To see more colors, click on More Colors at the bottom of the color palette to open the custom color palette.

Option 3 - Access the Ribbon Option with the Mouse:

1. Click on the tab of the worksheet to be renamed to make it the active sheet;

2. Click on the Home tab of the ribbon;

3. Click on the Format option on the ribbon to open the drop down menu;

4. In the Organize Sheets section of the menu, click on Tab Color to open the color palette;

5. Click on a color to select it;

6. To see more colors, click on More Colors at the bottom of the color palette to open the custom color palette.

Changing the Tab Color of Multiple Worksheets

Changing the sheet tab color for multiple worksheets requires those worksheets all be selected before using one of the methods outlined above.

The selected sheets can be contiguous -- beside each other -- such as sheets one, two, and three in the image above, or individual sheets can be selected - such as sheets four and six.

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

Selecting contiguous worksheets:

1. Click on the tab of the worksheet located on the left end of the group to be changed to make it the active sheet;

2. Hold down the Shift key on the keyboard;

3. Click on the tab of the worksheet on the right end of the group - all worksheets between the start and end sheets should be selected;

4. If too many sheets are selected by mistake, click on the correct end sheet - with the Shift key still pressed - to deselect the unwanted worksheets;

5. Use one of the methods outlined above to change the tab color for all selected sheets.

Selecting individual worksheets:

1. Click on the tab of the first worksheet to make it the active sheet;

2. Hold down the Ctrl key on the keyboard and click on the tabs of all the worksheets to be changed - they do not have to form a contiguous group - as shown with sheets four and six in the image above;

3. If a sheet is selected by mistake, click on it a second time - with the Ctrl key still pressed - to deselect it;

4. Use one of the methods outlined above to change the tab color for all selected sheets.

Tab Color Rules

When sheet tab colors are changed, the rules Excel follows in displaying the tab colors are:

  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(s) is underlined in the selected color - sheets four and six in the image above.
    • All other worksheet tabs display the selected color - sheets one, two, three, and five in the image.
Format
mla apa chicago
Your Citation
French, Ted. "3 Ways to Change Worksheet Tab Colors in Excel." ThoughtCo, Jun. 4, 2017, thoughtco.com/change-worksheet-tab-colors-in-excel-4020732. French, Ted. (2017, June 4). 3 Ways to Change Worksheet Tab Colors in Excel. Retrieved from https://www.thoughtco.com/change-worksheet-tab-colors-in-excel-4020732 French, Ted. "3 Ways to Change Worksheet Tab Colors in Excel." ThoughtCo. https://www.thoughtco.com/change-worksheet-tab-colors-in-excel-4020732 (accessed January 21, 2018).