- Select the sheets you want to color.
When you enter or change data, the changes affect all selected sheets. These changes may replace data on the active sheet and other selected sheets.
Note If sheet tabs have been color-coded, the sheet tab name will be underlined in a user-specified color when selected. If the sheet tab is displayed with a background color, the sheet has not been selected.
Cancel a selection of multiple sheets
To cancel a selection of multiple sheets in a workbook, click any unselected sheet.
If no unselected sheet is visible, right-click the tab of a selected sheet. Then click Ungroup Sheets on the shortcut menu.
- On the Format menu, point to Sheet, and then click Tab Color. You can also right-click on the sheet tab and then click Tab Color.
- Click on the color you want and click OK.