Excel 2010 Bible

Chapter 6: Worksheet Formatting

133

The following sections describe these procedures.

Modifying an existing style ......................................................................................

To change an existing style, choose Home ➪ Styles ➪ Cell Styles. Right-click the style you want to

modify and choose Modify from the shortcut menu. Excel displays the Style dialog box, shown in

Figure 6.13. In this example, the Style dialog box shows the settings for the Office theme Normal

style — which is the default style for all cells. The style definitions vary, depending on which doc-

ument theme is active.

FIGURE 6.13

Use the Style dialog box to modify named styles.

Here’s a quick example of how you can use styles to change the default font used throughout 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 (Figure
   6-13), with the current settings for the Normal style.


3. Click the Format button. Excel displays the Format Cells dialog box.


4. Click the Font tab and choose the font and size that you want as the default.


5. Click OK to return to the Style dialog box.


6. Click OK again to close the Style dialog box.

The font for all cells that use the Normal style changes to the font that you specified. You can

change any formatting attributes for any style.