- Tab colors can help you organize your table
- Change the color of a worksheet tab using keyboard or mouse keys
- Change tab color of multiple sheets
- Tab Color Rules
Tab colors can help you organize your table
It is often useful to colorize the sheet tabs of individual sheets of related data to organize a huge Excel spreadsheet file. Similarly, you can use different colored tabs to distinguish between worksheets that contain unrelated information.
Another option is to create a system of tab colors that provide a quick visual indication of the degree of completion of projects, e.g. green for current and red for completed projects.
Here are three options for changing the sheet tab color of a single sheet in a workbook:
Using keyboard keys.
Right click sheet tab (perhaps the easiest way).
Using the tab formatting option on the ribbon.
Applies to Excel 2013 and 2016.
Change the color of a worksheet tab using keyboard or mouse keys
Option 1 † Using keyboard shortcuts †
The Alt key in the sequence below does not need to be pressed while pressing other keys, as with some keyboard shortcuts. Each key is alternately pressed and released.
This sequence of keystrokes activates ribbon commands. After pressing and releasing the last key in the sequence – t – a color palette appears to change the color of the sheet tab.
1. Click the sheet tab to make it the active sheet, or use the following keyboard shortcuts to select the desired sheet:
ctrl † PgDn – go to the sheet on the right.
ctrl † pgup – go to the leaf on the left.
2. Successively press the following key combination: to open the color palette under the option Format tab At home on tape: alt † huh † ABOUT † t †
3. By default, the color square of the current tab color (surrounded by an orange frame) is highlighted in the palette. If you haven’t changed the color of the tab before, it will be white. Click the mouse pointer or use the arrow keys on your keyboard to move the selection to the desired color in the palette.
4. When using the arrow keys, press the Input on the keyboard to complete the color change.
5. Press the key. to see more colors m on the keyboard to open the custom color palette.
Option 2 † right click on the sheet tab †
1. Right click the tab of the sheet you want to recolor to make it the active sheet and 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 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 the tab of the sheet you want to rename to make it the active sheet.
2. Open a tab At home on the tape.
3. Press the button Format on the ribbon to open the drop-down menu.
4. Section Organize sheets menu click tab color to open the color palette.
5. Click on a color to select it.
6. To see more colors, click More colors at the bottom of the color palette to open the custom color palette.
Change tab color of multiple sheets
If you want to change sheet tab color for multiple sheets, you need to select all those tables before using any of the above methods.
The selected sheets can be adjacent – side by side, such as sheets one, two, three – or you can select individual sheets, such as sheets four and six.
All selected sheet tabs have the same color.
Select Adjacent Sheets
1. Go to the sheet tab in left end group you want to change to make it the active sheet.
2. Press and hold the key Shift on keyboard.
3. Click the sheet tab in right end groups – all sheets between the start and end sheet must be selected.
4. If you accidentally selected too many sheets, press the correct target sheet – with the key pressed Shift – to deselect unwanted sheets.
5.Use one of the above methods to change the tab color for all selected sheets.
Select individual sheets
1. Click the tab of the first sheet to make it the active sheet.
2. Press and hold the key ctrl click on the keyboard on the tabs of all the tables you want to change – they must not form a contiguous group – as shown on sheets 4 and 6 in the figure. above.
3. If the sheet was selected by mistake, click it again – while holding down the ctrl – to cancel its selection.
4. Use one of the above methods to change the tab color for all selected sheets.
Tab Color Rules
When changing sheet tab colors, Excel rules when displaying tab colors:
To change tab color for one sheet:
The sheet name is underlined in the selected color.
To change tab color for multiple sheets:
The tab(s) of the active worksheet are underlined in the selected color.
All other sheet tabs display the selected color.