"Offering free computer help, hints, and tips to the Internet populace." Now with over 3,820 tips!

Microsoft Excel 2010

Change the Tab Color of a Worksheet

SUMMARY: Tabs representing different worksheets in an Excel 2010 workbook can be colored for organizational purposes.

If you are editing a Microsoft Excel 2010 workbook containing multiple worksheets, you probably use the tabs at the bottom-left of the window to switch between them.

Instead of displaying all tabs in the same color, you might find it useful, especially if you have many tabs, to give them different colors. You might want to organize all worksheets related to a particular year in one color, or change tab colors representing P&L worksheets of particular quarters if the organization was in the red or black. You could also make every tab a different color for variety so you can tell people accounting is not boring.

1. Right-click a tab.

2. When the pop-up menu appears, select "Tab Color".

3. A secondary pop-up menu appears. Now you can choose a color from the theme or standard colors, or click "No Color" to remove the color.

If you want more color choices, click "More Colors" from the secondary popup to display a "Colors" dialog box. Here you can choose any color.

Change the color of a tab representing a worksheet in an Excel 2010 workbook

Return to the Microsoft Excel 2010 page.

Print this tip

Get the Newsletter

blog comments powered by Disqus

Thanks For Sharing!

Newest Tips:

Windows 8
Make it Easier to Differentiate Explorer Windows by Showing Full Paths
Google Chrome
Easily Share Content on Facebook, Pinterest, Twitter, More
Windows 8
Speed up Your Taskbar Thumbnail Previews
General Computers
[MODIFIED] Why Do Install Programs Ask Me to Close Everything or Restart?

Follow Us!

About MalekTips and the Author

The MalekTips website was created in 1998 by Andrew Malek of Envision Programming. The page's goal is to freely disperse computer-related tips, hints, and informative articles. Tips are organized to be easy to find, and are presented clearly, in easy-to-understand language. MalekTips also provides information and links to public-domain, open source, freeware, shareware, and commercial software available for download.