Try the Excel Course for Free!

Change Worksheet Tab Color in Excel – Instructions

/ / Excel 2013, Excel 2016, Excel 2019, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
Change Worksheet Tab Color in Excel - Instructions: A picture of a user changing the worksheet tab color in Excel.

Change Worksheet Tab Color in Excel: Overview

            You can change worksheet tab color in Excel, if desired. To do this, first select the worksheet tab whose tab color you wish to change. Next, click the “Home” tab in the Ribbon. Then click the “Format” button in the “Cells” button group. Then roll your mouse pointer down to the “Tab Color” command. In the side menu that appears, then click the color you want to apply to the worksheet tab.

Change Worksheet Tab Color in Excel - Instructions: A picture of a user changing the worksheet tab color in Excel.

Change Worksheet Tab Color in Excel – Instructions: A picture of a user changing the worksheet tab color in Excel.

            You can click the “More Colors…” menu choice to open the “Colors” dialog box and select a color, if necessary. To remove a color from a selected worksheet tab, select the “No Color” menu choice from the side menu, instead. Also note that when a worksheet tab is selected, or active, the true color is difficult to see. You can deselect the worksheet tab to more accurately view the color selection you made.

Change Worksheet Tab Color in Excel: Instructions

  1. To change worksheet tab color in Excel, select the worksheet tab whose tab color you wish to change.
  2. Click the “Home” tab in the Ribbon.
  3. Then click the “Format” button in the “Cells” button group.
  4. Then roll your mouse pointer down to the “Tab Color” command.
  5. In the side menu that appears, then click the color you want to apply to the worksheet tab.
  6. Alternatively, to open the “Colors” dialog box and select a color, click the “More Colors…” menu choice.
  7. Alternatively, to remove a color from a selected worksheet tab, click the “No Color” menu choice.
  8. To more accurately view the color selection you made, deselect the selected worksheet tab.

Change Worksheet Tab Color in Excel: Video Lesson

            The following video lesson, titled “Coloring Worksheet Tabs,” shows you how to change worksheet tab color in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.”

TOP