• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Tab Color in Excel

January 19, 2022 by Andrew Childress
Custom tab color Excel

Spreadsheets don't have to be boring. One great feature is setting the tab color let's earn how to do this in Excel. 

Spreadsheets don’t have to be boring. In fact, styling your workbook properly can make it easier for a user to navigate and work within.

One great feature is setting the tab color in Excel. This helps you set each sheet apart as a separate space. Let’s learn how to adjust tab color in Excel

Set Tab Color in Excel

You probably already know that each tab in a workbook is a separate workspace. Each spreadsheet is a unique view with data separate from the other sheets. These sheets can work together with formulas between them, but they’re also a great chance to help organize.

To set a tab color, right-click on it and choose the Tab Color menu. You’ll see a set of color swatches to choose from. When you click on the swatch, you’ll set the tab to the selected color.

Set tab color in Excel

Notice that while you still have the sheet selected, the tab color will appear differently than you might have expected.

Want to set the tab color for multiple sheets? That’s easy, too. Hold Control on your keyboard (or Command on macOS) and click on several sheets. Then, right-click and choose a color from the Tab Color menu. All of the selected sheets will take on the selected color.

How to Use Totally Custom Tab Colors in Excel

When you explored the tab color menu, you might have noticed that there were preset colors to choose from. If you’re feeling especially creative, it helps to know that these aren’t your only options.

On the Tab Color menu, try out the More Colors… menu. Then, choose a new color swatch from the Standard tab. Or, switch to the Custom tab to input a hex code.

Custom tab color Excel

Every spreadsheet is an opportunity to express yourself creatively. Use tab colors to set your sheets apart in the workbook.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « Delete sheet rows in Excel Insert Sheet Rows in Excel
Next Post: CHOOSE in Excel Choose Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top