Microsoft Excel: Organize Your Worksheet Tabs With Color

Article by Mr Excel (11,387 pts ) , published Aug 26, 2008

Problem: As shown in Fig. 1269, you have a lot of tabs in the workbook. Can you highlight the frequently used tabs in red?

See all Microsoft Excel tips

Strategy: Starting in Excel 2000, you can use Format – Sheet – Tab Color to assign a color to the tab of the current worksheet, as shown in Fig. 1270.

Summary: Organize your sheets visually by changing the color of the sheet tabs.

Commands Discussed: Format – Sheet – Tab Color

See all Microsoft Excel tips

Images

Fig. 1269Fig. 1270
 
Subscribe to Home Office
RSS
Get free weekly updates, directly to your inbox.