"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:

Google Chrome
[MODIFIED] Add Button to Scroll to Top of Long Web Pages
Google Gmail
Show Maps Automatically in Emails Instead of Copying and Pasting
Windows 8
Shrink the Taskbar Buttons
Sites to Browse - DVDs - Movies
[MODIFIED] Learn to Talk like Yoda

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.