O'Reilly logo

Master Visually®: Excel® 2007 by Elaine Marmel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7. Managing Workbook Structure

Set Worksheet Tab Colors

You can assign colors to worksheet tabs to help you identify a worksheet's contents. For example, suppose that your organization has set standards for workbooks that store product sales to help easily evaluate sales for different time periods. In your organization, each workbook that stores product sales numbers should contain four worksheets, with each worksheet storing only one quarter's information. You can color code the worksheet tabs so that, in each workbook, sales for the first quarter always appear on a worksheet that has a red tab. You might assign yellow to the second quarter, green to the third quarter, and blue to the fourth quarter.

To keep your color coding consistent, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required