Changing Worksheet Tab Colors

A great way to make any worksheet element stand out is to change it to a color that contrasts with the other colors used in the worksheet. In Excel, you can change the color of sheet tabs. For example, you can change the color of a sheet tab in a workbook in which you track sales for a year, with a worksheet for each month. Rather than move the current worksheet to the front of the list, which would put the worksheets out of order, you can change the color of the sheet tab to make it stand out. When the month ends, you can remove the color from that sheet tab and apply it to the new month’s sheet tab.

Color a Sheet Tab

  1. Hold down the Ctrl key and click the sheet tabs you want to color.

  2. Right-click the selection and point to Tab Color on the shortcut menu.

  3. Select the color you want.

    Color a Sheet Tab

    Tip

    Tip

    If you don’t see the tab color you want in the Tab Color palette, click More Colors to display the Colors dialog box.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.147.59.219