Changing a spreadsheet tabs color

Excel 2016 2013 2010 2007 2003
Color code is a perfect way to identify content and draw attention to it. In Excel, you can easily change the colors of one or more spreadsheet tabs (see how to group multiple sheets).

For example, you may prefer to use color-coded worksheet tabs to make it easier to identify which worksheet has been completed or reviewed and which needs more work. Or you prefer to mark different years by the colors of the comparison chart:

spreadsheet tabs Color in Excel 365

To change the color of an Excel sheet tab, right-click the tab and choose Tab Color.

Then select the color:

spreadsheet tabs Color in Excel 365

Notes:

  1. You can't change the color of the text, but Excel will automatically choose a contrasting color so that the text is visible, as it is for 2018 in the first example.
  2. If you change the color of a sheet tab, the color will only be visible when the sheet is not active.

See also this tip in French: Comment modifier la couleur des onglets de la feuille de calcule.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.

Change color for gridlines in Excel

Change color for gridlines in Excel

By default, gridlines are displayed in worksheets using a color assigned by Excel. But if you want, you can change the color of the gridlines for a worksheet (see also How to turn on and turn off gridlines in Excel and How to change width of gridlines in Excel).
Working with spreadsheets

Working with spreadsheets

This tip describes shortcut keys that can be useful for adding, deleting, moving, or coping spreadsheets. See also how to change the color for worksheet tabs, making the spreadsheet very hidden.
Grouping and ungrouping sheets

Grouping and ungrouping sheets

Sheets can be grouped (connected) to facilitate creating or formatting two or more identical sheets. For example, you can create one sheet and copy it to two other sheets, or you can group three blank sheets and enter and format the content once-no subsequent copying is required.