Separating Worksheets with Tab Colors

If you need to store multiple worksheets within the same Excel workbook file, you can apply a unique color to each worksheet tab. The colors enable you to more easily distinguish the worksheet tabs at the bottom of the screen.

To apply a color to a worksheet tab, right-click any worksheet tab and select Tab Color. Excel displays a color palette from which you can select.

The tab colors affect only the tab and not the worksheet. After you click a tab to bring that worksheet into focus, the tab color, just as the worksheet (unless you've modified the worksheet's background) becomes white.