RSS Home Newsletter Advertising
Visit Twellow.com

Color-Coding Worksheet Tabs in Excel

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

Digg This! StumbleUpon This!


News Tags: Excel, HTTP, Manage
About the author:
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

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
9 + 11 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.