Excel 2019 Bible

Part I: Getting Started with Excel

FIGURE 5.21

Excel displays samples of predefined cell styles.

After you apply a style to a cell, you can apply additional formatting to it by using any for-

matting method discussed in this chapter. Formatting modifications that you make to the

cell don’t affect other cells that use the same style.

You have quite a bit of control over styles. In fact, you can do any of the following:

■ (^) Modify an existing style.
■ (^) Create a new style.
■ (^) Merge styles from another workbook into the active workbook.
The following sections describe these procedures.
Modifying an existing style
To change an existing style, choose Home ➪ Styles ➪ Cell Styles. Right-click the style that
you want to modify and choose Modify from the shortcut menu. Excel displays the Style
dialog box, as shown in Figure 5.22. In this example, the Style dialog box shows the set-
tings for the Office theme Normal style—which is the default style for all cells. The style
definitions vary, depending on which document theme is active.
Here’s a quick example of how you can use styles to change the default font used through-
out your workbook:

1. Choose Home ➪ Styles ➪ Cell Styles. Excels displays the list of styles for the active
   workbook.


2. Right-click Normal and choose Modify. Excel displays the Style dialog box (refer to
   Figure 5.22), with the current settings for the Normal style.