- Select a cell that has the combination of formats you want to include in the new style. (You can specify the formats when you name the style.)
- On the Format menu, click Style.
- In the Style name box, type a name for the new style.
- To define and apply the style to the selected cells, click OK.
To define the style without applying it, click Add, and then click Close.
- On the Format menu, click Style.
- In the Style name box, type a name for a new style.
To change formats for an existing style, click the style you want to change.
- Click Modify.
- On any of the tabs in the dialog box, select the formats you want, and then click OK.
- Clear the check box for any type of formats that you don't want the style to include.
- To define and apply the style to the selected cells, click OK.
To define the style without applying it, click Add, and then click Close.
Remove a style from selected cells
- Select the cells that are formatted with the style you want to remove.
- On the Format menu, click Style.
- In the Style name box, click Normal.
Delete a style from the style list
- On the Format menu, click Style.
- In the Style name box, click the style you want to delete.
- Click Delete.
Note You cannot delete the Normal style. If you delete the Currency, Comma, or Percent style, you won't be able to use the Comma Style , Currency Style , or Percent Style button on the Formatting toolbar.