Page 34 - Excel Data Analysis

02 537547 Ch01.qxd 3/4/03 11:45 AM Page 20

EXCEL DATA ANALYSIS

CREATE A NAMED STYLE

f you consistently apply specific formatting options style Excel applies to all cells of your worksheet. The other
within a worksheet, you can use a named style to styles provide default Number formats for formatting
I simplify the formatting process. When you have a style numbers with commas, currency, or percent.
that contains the formatting you want, you simply apply that You modify default style format options using the six tabs in
style to selected cells within a worksheet. For example, you the Format Cells dialog box: Number, Alignment, Font,
can create a Stocks style that changes numbers to fractional Border, Patterns, and Protection. You can modify the various
values and displays them in Arial 10 point font and bold. The properties of your style by selecting options in any one of
advantage of creating and applying style is that you can these tabs. For example, if you specify that you want to
update them to suit your needs. For example, if you want center the text within the cell, the Alignment option
your Stocks style to apply italics to your worksheet, you displays the value: Horizontal Center.
simply modify the style, and Excel automatically updates the
formatting in all cells using that style. When you create a new style, it becomes a part of only the
existing workbook. To make the style available to other
You create styles from the Style dialog box by modifying an workbooks, you need to create a template. See the section
existing style. Excel provides six default styles, which you "Create a Custom Template" for more information about
can select in the Style name field. Normal is the default
creating templates.

CREATE A NAMED STYLE

⁄ Select the cells where you Note: See the section "Select a Range ■ The Style dialog box ‹ Type a name for your
want to apply the style. of Cells" for more information. displays. style.
¤ Click Format ➪ Style. › Click Modify.

20