Applying Styles

A style is the combination of effects that can be applied at one time. Styles can include formatting such as character effects, background color, typefaces, and number formatting. Excel comes with predefined styles including Currency, Comma, and Percent styles, but also gives you the ability to create your own styles in the Style dialog box.



To apply a basic style:

  1. Select the cells you want to format.
  2. Click Style... on the Format menu.
  3. Click the arrow next to the Style name box and select the style you want.
  4. Review the effects included in the style (click the Modify... button to make any changes to the style).
  5. Click OK.


To change the effects included in the style, click the Modify... button in the Style dialog box.

To apply styles from the Formatting toolbar:

  1. Currency Style: click
  2. Comma Style: click
  3. Percent Style: click