Color-Coding Worksheet Tabs in Excel

Get the WebProNews Newsletter:

[ Business]

You can color code worksheet tabs to make them easier to recognize. Tabs for inactive sheets will have a solid background in the chosen color. The tab for the active sheet is underlined in the chosen color. There are 56 colors to choose from.

1. Select the tab(s) for the worksheets you want to color.

2. Right-click on one of the selected tabs and choose Tab Color from the shortcut menu.

3. Select a color and then click the OK button.

An example of color-coded worksheets is shown below.

Beth Sunny and Karin Rex share their extensive knowledge in IT and training as freelance writers for http://www.SharperTraining.com. Don’t miss their training tips along with insights from other experienced trainers in SharperTraining.com’s “Focus On Training” newsletter. To subscribe, visit http://lb.bcentral.com/ex/manage/subscriberprefs.aspx?customerid=1468

Color-Coding Worksheet Tabs in Excel
Comments Off
Top Rated White Papers and Resources

Comments are closed.

  • Join for Access to Our Exclusive Web Tools
  • Sidebar Top
  • Sidebar Middle
  • Sign Up For The Free Newsletter
  • Sidebar Bottom