Microsoft Excel Whiz 2002 2003

Lesson 4: Applying Styles

A style is a combination of formatting characters, such as font, font size, and indentation, that you name and store as a set. When you apply a style, all of the formatting instructions in that style are applied at one time.

Applying a Style

  1. Select the cells you want to format.

  2. On the Format menu, click Style. The Style dialog box appears.

  3. In the Style name list box, click the style you want.

  4. Click OK.

To define the style without applying it, click Add, and then click Close.

Note

To apply common number styles to selected cells, click Comma, Currency or Percent style on the Formatting toolbar.

Creating a New Style

  1. Select a cell that has the combination of formats you want to include in the new style.

  2. On the Format menu, click Style.

  3. In the Style name box, type a name for the new style. To change formats for an existing style, click the style you want to change.

  4. Click Modify.

  5. On any of the tabs in the dialog box, select the formats you want, then click OK.

  6. Clear the check box for any type of formats that you don't want the style to include.

  7. 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.

Removing 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.

Deleting 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 will not be able to use the Comma Style , Currency Style , or Percent Style button on the Formatting toolbar.

Whiz Words

Style

Currency

Percent

Comma

Lesson Summary

Styles contains a mixture of font, alignment, border, and pattern formatting. It also adds one or more formats to a range. You can define and modify the formats associated with a style.

Study Help

  1. What is a style?

  2. How do we remove a style from selected cells?

  3. How do we delete a style form the style list?

Activity 1

  1. Open a new workbook.

  2. Create a new style named My Style.

  3. The Style should include the following:

    • Number - Date

    • Alignment Center, Bottom

    • Font Times New Roman, 12

    • Borders No Border

    • Shading Lime Green

    • Protection Locked

  4. Click Add, and then Close.

  5. Display the Style dialog box again.

  6. Look for the style you have created in the Style name list box.

  7. Click Close.

  8. Exit MS Excel without saving it.

Related

Категории