Defining Cell Styles

When you develop a worksheet, you will probably create a set of formats you want to apply consistently to certain parts of it. For example, you might always want your column headings to be slightly larger and in a different font than the body of the worksheet. You can save the formatting you want for a worksheet element and save it as a style, which you then can apply to appropriate parts of your worksheets. Excel 2007 makes using styles much easier than in previous versions. Not only do you have more built-in styles from which to choose, it’s no trouble to create a custom style of your own.

Apply a Style

  1. Select the cells you want to change.

  2. Click the Home tab.

  3. In the Styles group, click Cell Styles.

  4. Click a style.

    Apply a Style

    Tip

    Tip

    When you hover the mouse pointer over a style, the selected cells change their appearance to preview how the cells would appear if you applied that style.

Create a Style

  1. Click the Home tab.

  2. In the Styles group on the ribbon, click Cell Styles.

  3. Click New Cell Style.

  4. Type a new style name.

  5. Click Format.

  6. Specify the formatting you want this style to contain.

  7. Click OK.

  8. Click OK.

    Create a Style
    Create a Style
    Create a Style

    Tip

    Tip

    If you want to immediately apply a new style after creating it, select the cells first, create your style, and then click OK instead of Close.

    Tip

    Tip

    Any custom styles you create will appear at the top of the Cell Styles gallery.

Modify a Style

  1. Click the Home tab.

  2. In the Styles group on the ribbon, click Cell Styles.

  3. Right-click the style you want to modify.

  4. Click Modify.

  5. Click Format.

  6. Specify the formatting you want.

  7. Click OK twice.

    Modify a Style
    Modify a Style

Delete a Style

  1. Click the Home tab.

  2. In the Styles group on the ribbon, click Cell Styles.

  3. Right-click the style you want to delete.

  4. Click Delete.

    Delete a Style
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.191.205.99