Everyday Computing Advanced Computing The Internet At Home Health, Mind & Body Making & Managing Money Sports & Leisure Travel Beyond The Classroom
Handheld Computing
Hardware
Money Management Software
Multimedia
Office Productivity Software
Operating Systems
Moms, Dads, and Grads -- Win $500!
Excel 2003 For Dummies

Changing the Color of a Sheet Tab in Excel 2003


Adapted From: Excel 2003 For Dummies

In Excel 2003, you can assign colors to the different worksheet tabs. This feature enables you to color-code different worksheets. For example, you could assign red to the tabs of those worksheets that need immediate checking and blue to the tabs of those sheets that you've already checked.

To assign a color to a worksheet tab, right-click the tab and choose Tab Color from its shortcut menu to open the Format Tab Color dialog box. Click the color that you want to assign to the selected sheet tab in the Format Tab Color dialog box, and then click OK. When the Format Tab Color dialog box disappears, the name of the active sheet tab appears underlined in the color you just selected. When you make another sheet tab active, the entire tab takes on the assigned color (and the text of the tab name changes to white if the selected color is sufficiently dark that black lettering is impossible to read).

To remove a color from a tab, open the Format Tab Color dialog box from the tab's shortcut menu and then choose the No Color selection at the very top before clicking OK.

Related Articles
Formatting the X-Axis or Y-Axis of a Chart in Excel 2002
Ordering Up Organizational Charts in Excel 2002
Saving a Static Web Page in Excel 2002
Taming the Excel 2002 Task Panes
Using Office XP on Your Pocket PC
Related Titles
Excel 2007 Just the Steps For Dummies
Microsoft Office Live For Dummies
Excel 2007 Workbook For Dummies
Crystal Xcelsius For Dummies
Excel 97 For Windows For Dummies