Microsoft Office Tutorials and References
In Depth Information
Formatting Sheet Tabs
In addition to the sheet background, you can also format the background color of work-
sheet tabs. This color is only visible when the worksheet is not the active sheet in the
workbook. By default, the tab of the active sheet in a workbook is white. If you change
the color of a tab, the tab changes to white with a narrow colored stripe at the bottom of
the tab when the sheet is active. You can use tab colors to better organize the various
sheets in your workbook. For example, worksheets that contain sales information could
be formatted with blue tabs, whereas sheets that describe the company’s cash flow or
budget could be formatted with green tabs. To explore how to color worksheet tabs, you
will change the tab color of the Sales worksheet to light orange.
To change the tab color:
1. Right-click the Sales tab, and then click Tab Color on the shortcut menu. The Format Tab
Color dialog box opens.
2. Click the Light Orange square (third row, second column from the left) in the color palette,
and then click the OK button. Because the Sales sheet is the active worksheet, the tab is
white with a light-orange horizontal stripe at the bottom of the tab.
3. Switch to the Documentation sheet so you can see the light-orange color of the Sales sheet
tab, and then switch to the Sales sheet again.
Clearing and Replacing Formats
Sometimes you might want to change or remove some of the formatting from your work-
books. As you experiment with different formats, you can use the Undo button on the
Standard toolbar to remove formatting choices that did not work out as well as you
expected. Another choice is to clear the formatting from the selected cells, returning the
cells to their previous format. To see how this option works, you will remove the format-
ting from the company name in cell A1 on the Sales worksheet.
To clear the formatting from cell A1:
1. Make sure cell A1 is selected.
2. Click Edit on the menu bar, point to Clear , and then click Formats . Excel removes the for-
matting that was applied to the text and removes the formatting that merged the cells and
then centered the text across the range.
3. Click the Undo button
on the Standard toolbar to undo your action, restoring the for-
mats you cleared.
Sometimes you will want to make a formatting change that applies to several different
cells. If those cells are scattered throughout the workbook, you may find it time consum-
ing to search for and replace the formats for each individual cell. If the cells share a com-
mon format that you want to change, you can use the Find and Replace command to
locate the formats and modify them.