Microsoft Excel: Organize Your Worksheet Tabs With Color

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