Change tab color by right-clicking the sheet tab

The fastest way to change a sheet tab color in Excel is to right-click the tab at the bottom of your screen and select Tab Color from the menu. A color palette appears with preset colors and an option to pick a custom color. Click the color you want, and the tab updates when ready.

This method works the same way in Excel for Windows and Excel for Mac. The tab name stays readable — Excel automatically adjusts the text color to black or white depending on which background color you choose, so dark tabs get light text and light tabs get dark text.

You can change multiple tabs at once by holding Ctrl (or Command on Mac) and clicking each tab you want to modify, then right-clicking and selecting Tab Color. All selected tabs will change to the same color.

Key Takeaways

  • Right-click any sheet tab at the bottom of the screen and select Tab Color to open the color picker.
  • Excel offers preset colors in the palette, or you can click More Colors to choose from thousands of custom shades.
  • Select multiple tabs by holding Ctrl (Windows) or Command (Mac) before right-clicking to change several tabs to the same color at once.
  • The tab text color adjusts automatically — you do not need to change it separately.
  • To remove a tab color and return it to the default white, right-click the tab and select Tab Color, then click No Color.

Access the color menu through the Sheet menu

If right-clicking does not work or you prefer using the menu bar, you can change tab color through the Sheet menu. Click the Sheet tab in the ribbon at the top, then look for Tab Color in the Cells group (Windows) or the Sheet group (Mac).

This route requires you to click the sheet tab first to select it, then navigate to the menu. It takes one extra step compared to right-clicking, but produces the same result. The color palette that opens is identical.

Choose from preset colors or create a custom color

The standard color palette in Excel includes about 10 preset colors: red, orange, yellow, green, blue, purple, and variations. These colors are designed to be distinct from one another, so they work well for organizing sheets by category or department.

If none of the presets match what you need, click More Colors at the bottom of the palette. A dialog box opens where you can enter RGB values, hex codes, or pick a color from a gradient. This is useful if your workbook needs to match a company color scheme or if you want subtle shades that the preset palette does not offer.

Custom colors you create are saved only in that workbook. If you create the same color in a different file, you will need to enter the values again — Excel does not carry custom colors between files.

Organize workbooks by using different colors for different sheet types

Color-coding tabs makes large workbooks easier to navigate. A common pattern is to use one color for data sheets, another for summary sheets, and a third for reference or archive sheets. This visual system helps you and anyone else using the file find the right sheet without reading every tab name.

For example, you might use blue for raw data, green for calculated summaries, and gray for archived months. The specific colors matter less than consistency — pick a scheme at the start and stick to it so the pattern becomes automatic.

If your workbook has many sheets, consider using color plus a naming convention together. A tab labeled "Data_Jan" in blue and another labeled "Summary_Jan" in green tells the reader both what the sheet contains and what type of information it holds.

Remove or reset tab colors

To remove a color from a tab and return it to white, right-click the colored tab and select Tab Color. At the bottom of the color palette, click No Color. The tab reverts to the default appearance.

If you want to remove color from multiple tabs at once, select them all by holding Ctrl (or Command on Mac) and clicking each one, then right-click and choose Tab Color and No Color. All selected tabs clear at the same time.

Tab colors do not affect printing or file size

Changing tab colors is purely visual — it does not change what prints when you print the sheet, and it does not increase the file size of your workbook. The color information is stored in the file, but it is minimal data.

If you share a workbook with someone using an older version of Excel or a different spreadsheet program, the tab colors may not display the same way or may not appear at all. The data itself is unaffected. When the file is opened in a program that supports tab colors, they will display as you set them.

Frequently Asked Questions

Can I change the color of just the text on a tab, not the background?

No. Excel only lets you change the background color of the tab itself. The text color adjusts automatically based on the background color you choose — you cannot set them independently. If you need a specific text appearance, the background color you pick will determine it.

Will the tab colors show up if I email the file to someone else?

Yes, as long as they open the file in Excel or a compatible spreadsheet program that supports tab colors. If they use an older version of Excel or a different program, the colors may not display. The data in the sheets is not affected either way.

Can I use a pattern or gradient for a tab, or only solid colors?

Only solid colors. Excel does not offer patterns, gradients, or images for sheet tabs. You can pick from the preset palette or create a custom solid color using RGB or hex values, but the tab background will always be a single flat color.

What happens to tab colors if I copy a sheet to a different workbook?

The tab color does not copy with the sheet. When you copy or move a sheet to another workbook, it arrives with the default white tab. You will need to set the color again in the new file if you want it to match your color scheme there.

Is there a limit to how many different colors I can use for tabs?

No. You can assign a different color to every sheet in your workbook. Excel supports thousands of custom colors, so you can color-code as many tabs as you need. However, using too many different colors makes the system harder to read — most workbooks work better with three to five colors total.