How to Change Tab Color in Excel: A Practical Guide

How-to basics · Updated November 20, 2026

To change a worksheet tab color in Excel for Microsoft 365 on Windows, right-click the sheet tab, choose Tab Color, and select a color. On a Mac or in Excel for the web, use the sheet tab’s context menu if available; the color helps you spot and organize sheets, but it does not change the worksheet’s contents or print appearance.

You can color one tab at a time or apply a color to several selected worksheets together. The steps below cover the usual Windows method first, then note where Mac and web controls may differ.

What You’ll Need

  • An Excel workbook with at least one worksheet. If the workbook is read-only or you do not have permission to edit it, you may need an editable copy.
  • Access to the worksheet tabs along the bottom of the Excel window. If you cannot see them, check the troubleshooting section.
  • A color plan if the workbook has many sheets. For example, reserve blue for input sheets and green for completed reports, and use a text label as well as color to distinguish important tabs.

Step-by-Step

  1. Open the workbook and locate the sheet tab. Open the workbook in Excel for Microsoft 365 on Windows. At the bottom of the window, find the tab for the worksheet you want to mark, such as Summary or January. If you are unsure which sheet a tab represents, click it first and check the worksheet content before changing its color.
  2. Open the tab’s context menu. Right-click the worksheet tab. On a Windows laptop with a trackpad, a two-finger click or a right-click gesture may open the same menu. If you have selected more than one tab, pause and check your selection before continuing; a color change can affect every selected worksheet.
  3. Choose Tab Color. In the context menu, point to or select Tab Color. Excel displays a palette. Depending on the version and available controls, it may show theme colors, standard colors, and an option for more colors. The exact palette layout can look a little different across Windows, Mac, and web versions.
  4. Select a color. Click a swatch to apply it. Choose a color with enough contrast against the tab background so it is easy to recognize. If you do not want to decide immediately, you can choose a temporary color and change it later; assigning a tab color does not lock the worksheet or affect its data.
  5. Check the result on the tab. Look at the worksheet tab and confirm that the color appears. The selected, active tab can display its color differently from inactive tabs; depending on the Excel version and theme, you may see the color as an accent or along part of the tab rather than as a solid block. Click another sheet to compare the tabs if the active-sheet appearance makes the color hard to judge.
  6. Repeat for other worksheets. Right-click each additional tab and repeat the Tab Color selection. To color a contiguous group, click the first tab, hold Shift, and click the last tab. To select separate tabs, hold Ctrl while clicking each one on Windows. Then right-click one of the selected tabs and choose a color. Use grouping carefully: changes made while worksheets are grouped may affect all selected sheets. When finished, click a single worksheet tab to ungroup them.
  7. Save the workbook. Press Ctrl+S on Windows, or choose File > Save. The tab colors are saved as part of the workbook. If you are editing a shared file, wait for the save or sync indicator to finish before closing it.

Ribbon alternative on Windows: Select the worksheet, then use Home > Cells > Format > Tab Color and pick a swatch. If the ribbon is collapsed, expand it or use the right-click method instead. You can also right-click a tab and choose Tab Color > No Color to remove its assigned color, when that option is shown.

On Mac: Control-click the worksheet tab, or right-click it if your mouse or trackpad is configured for secondary clicking, then choose Tab Color and select a swatch. The menu wording is similar, though the palette and available custom-color controls may vary by Excel version. In Excel for the web: right-click the sheet tab and look for Tab Color. If the command is missing in your browser or account, open the workbook in the desktop app to set the color. After editing online, make sure the file has finished saving.

Common Mistakes

  • Changing the wrong sheet. It is easy to right-click a neighboring tab, especially when tabs are narrow or many sheets are open. Confirm the sheet name before choosing the color. If you apply it to the wrong tab, repeat the steps on the intended tab and remove the color from the mistaken one.
  • Leaving several sheets grouped. A group is indicated by multiple highlighted tabs or a grouped-sheet note in the title bar in some versions. While sheets are grouped, certain edits can be applied to all of them. After coloring a group, click a single tab to return to normal editing before entering or changing worksheet data.
  • Expecting the tab color to format cells. Tab Color only marks the worksheet tab. It does not color cells, headings, charts, or the sheet when printed. To format cells, select the relevant range and use the fill-color controls on the Home tab.
  • Choosing colors that are too similar. Several nearly identical shades do not help you find a sheet faster. Pick visibly distinct colors, and use short, descriptive sheet names as a second cue. This is especially useful for people who may not distinguish every color in the palette.
  • Assuming the active tab is uncolored. Excel may present the active sheet differently from inactive tabs. A color that appears subtle while that worksheet is selected may be easier to see after you click another tab. Check both states before deciding the color failed.
  • Forgetting to save or sync. A color can appear on screen before a shared or cloud-stored workbook has finished saving. Save the file and check for any upload or sync warning before you close Excel or switch devices.

Tips

  • Make a simple color key. For a workbook used by a team, decide what each color means and record the key on a cover or instructions sheet. For example, blue could identify data-entry sheets, green could mark reviewed sheets, and orange could mark reference sheets. Treat this as a visual convention rather than a security or approval control.
  • Use a small number of categories. A few consistent colors are easier to remember than a different color for every worksheet. If you have many monthly sheets, for instance, use the same color for every month and a contrasting color for the annual summary.
  • Pair color with names and position. Rename tabs with meaningful labels and put related sheets next to each other. You can drag a tab left or right to reorder it. Color, clear names, and a sensible order work together, while color alone may not communicate what a sheet contains.
  • Keep accessibility in mind. Do not use color as the only way to signal an important status. Add words such as Draft, Reviewed, or Input to the sheet name or include a legend. This makes the workbook easier to navigate for people who use screen magnification or have difficulty distinguishing colors.
  • Use the workbook’s existing theme where practical. Theme colors usually coordinate with the workbook’s other formatting. If you choose a custom shade, check it on the workbook’s background and on both active and inactive tabs. A very light shade may be difficult to see in some display themes.
  • Remember that tab colors are organizational, not protective. A red tab does not prevent edits, and a green tab does not prove that a sheet has been checked. Use worksheet protection or clear review procedures if you need actual controls, and keep tab color as a quick visual aid.

Troubleshooting

I cannot see the worksheet tabs. First, check whether the workbook window is wide enough; the tab-navigation buttons can take up space. On Windows, open File > Options > Advanced, scroll to Display options for this workbook, and check that Show sheet tabs is selected. If the tabs are present but crowded, use the navigation arrows at the lower left or widen the Excel window. On Mac, check Excel’s display preferences for worksheet-tab visibility; menu names may vary by release.

Tab Color is missing or unavailable. Confirm that you opened the menu for a worksheet tab, not a cell or the workbook title. If the workbook is protected, shared under restrictions, or opened with view-only access, editing commands may be limited. Ask the file owner for edit permission, or use File > Save As to create an editable copy when permitted. In Excel for the web, use the desktop app if the browser version does not show the color command.

The color seems not to have changed. Click a different worksheet so the tab you colored is inactive, then inspect it again. Active-tab styling can make its assigned color less obvious. Also check whether you chose a color close to the interface background. Reopen Tab Color and select a more contrasting swatch if needed.

The wrong worksheets changed color. If the sheets are still grouped, right-click a selected tab, choose Tab Color, and apply the intended color to that group, or remove the color and correct each sheet individually. Then click a single tab to ungroup the sheets. If the workbook has already been saved and you are unsure what changed, use Ctrl+Z on Windows or Command+Z on Mac promptly; undo availability can depend on subsequent actions and the current session.

The color did not appear on a printout. That is expected: worksheet tab colors are an on-screen navigation aid and are not printed as part of the worksheet. If printed pages need identification, add a heading, footer, or cell formatting to the sheet itself.

Frequently Asked Questions

Can I change a worksheet tab color in Excel for the web?
Often, yes. Right-click the worksheet tab and choose Tab Color if the command is available. If it is not shown, open the workbook in the Excel desktop app, set the color there, and allow the file to save.

Can I assign a custom color instead of a preset swatch?
Some desktop versions provide a custom-color option, such as More Colors, in the Tab Color palette. Availability and controls vary by platform. If your palette only offers preset colors, choose the closest available shade or use a desktop version with custom colors.

How do I remove a tab color?
Right-click the worksheet tab, open Tab Color, and select No Color if that option appears. The tab returns to its default appearance; its worksheet data and cell formatting remain unchanged.

Can one color be applied to multiple tabs at once?
Yes. Select adjacent tabs with Shift-click or separate tabs with Ctrl-click on Windows, then open the context menu for a selected tab and choose a color. On Mac, use the platform’s modifier keys for selecting multiple tabs. Confirm the selected group first, because the same color will be applied to all selected worksheets.

Will tab colors remain when I share or print the workbook?
They are saved in the workbook and generally remain visible when another person opens the file in a compatible Excel version. They are not printed on worksheet pages. For important instructions, add a text label or legend rather than relying on a color alone.

Does changing a tab color change the color of cells in that worksheet?
No. It only changes the worksheet’s tab appearance. To change cell colors, select the cells and use the fill-color button on Home; that is a separate formatting action.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.