Lesson 4: Applying Styles


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.

    click to expand

  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

start example

Style

Currency

Percent

Comma

end example

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

start example
  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?






end example

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

end sidebar




Microsoft Excel Whiz 2002 2003
Microsoft Excel Whiz 2002 2003
ISBN: N/A
EAN: N/A
Year: 2004
Pages: 66

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net