Chapter 6. Managing the Workbook Structure

Set Worksheet Tab Colors

You can assign colors to worksheet tabs to help you identify a worksheet's contents. For example, suppose your organization has set standards for workbooks that store product 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, for example, 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, your organization ...

Get Master VISUALLY® Excel® 2010 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.