Changing a spreadsheet tabs color

Excel 2016
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.