Microsoft Office Tutorials and References
In Depth Information
If you have several cells that employ the same format, you can create a style for those cells.
This can be a faster and more efficient way of updating formats than copying and replacing
formats. A style is a saved collection of formatting options—number formats, text alignment,
font sizes and colors, borders, and background fills—that can be applied to cells in a work-
sheet. When you apply a style, Excel remembers which styles are associated with which
cells in the workbook. If you want to change the appearance of a particular type of cell, you
need only modify the specifications for the style, and the appearance of any cell associated
with that style will be automatically changed to reflect the new style.
You can create a style in one of two ways: by selecting a cell from the worksheet and
basing the style definition on the formatting choices already defined for that cell or by
manually entering the style definitions into a dialog box. Once you create and name a
style, you can apply it to cells in the workbook.
Excel has eight built-in styles: Comma, Comma , Currency, Currency , Followed
Hyperlink, Hyperlink, Normal, and Percent. You have been using styles all of this time with-
out knowing it. Most cells are formatted with the Normal style, but when you use the Percent
Style button, Excel formats the selected text using the definitions contained in the Percent
style. Similarly, the Currency Style button applies the format as defined in the Currency style.
As you’ll see, you can modify these style definitions or create some of your own.
Creating a Style
Joan wants you to further modify the appearance of the worksheet by changing the back-
ground color of the months in the first table and the monitor names in the second table to
yellow. Rather than applying new formatting to the cells, you will create a new style called
“Category” and then apply the new style to the category columns of the tables in the work-
sheet. You will create the style using the format already applied to cell A7as a basis.
To create a style using a formatted cell:
1. Click cell A7 to select it. The format applied to this cell becomes the basis of the new style
that you want to create.
2. Click Format on the menu bar, and then click Style . The Style dialog box opens. All of the
formatting options associated with the style of the active cell are listed. For example, the
font is 10-point Arial. The check boxes indicate whether these various formatting categories
are part of the style definition. If you deselect one of the formatting categories, such as
Border, then that category will not be part of the style definition.
To create a new style for this cell, you simply type a different name into the list box.
3. Type Category in the Style name list box, as shown in Figure 3-26. At this point, cell A7 is
no longer formatted using the Normal style; rather it is formatted using the Category style
you just created.