Colors and Fonts for Worksheet Tabs

Excel is quite configurable in how information appears on your screen. At some time you may want to change the appearance of the worksheet tabs at the bottom of your workbook. Unfortunately, Excel allows very little customization of the way worksheet tabs are presented.

If you want to change the font used in a worksheet tab, you need to change the fonts used by Windows (not Excel) to displays information. You can use the Windows Control Panel to modify the appearance of information within your system. Understand, however, that such changes affect all programs running on your system, not just Excel.

If you want to change the color used to display a worksheet tab, you can follow these steps:

  1. Right-click on the worksheet tab you want to change. Excel displays a Context menu.
  2. Choose Tab Color from the Context menu. Excel displays a palette of available colors.
  3. Select a color to use for the tab.