Create or delete a style

Microsoft Office Excel 2003

  1. 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.)
  2. On the Format menu, click Style.
  3. In the Style name box, type a name for the new style.
  4. 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.

ShowSpecify formats for a style

  1. On the Format menu, click Style.
  2. 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.

  3. Click Modify.
  4. On any of the tabs in the dialog box, select the formats you want, and then click OK.
  5. Clear the check box for any type of formats that you don't want the style to include.
  6. 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.

ShowRemove a style from selected cells

  1. Select the cells that are formatted with the style you want to remove.
  2. On the Format menu, click Style.
  3. In the Style name box, click Normal.

ShowDelete a style from the style list

  1. On the Format menu, click Style.
  2. In the Style name box, click the style you want to delete.
  3. 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 Button image, Currency Style Button image, or Percent Style Button image button on the Formatting toolbar.