Chapter 5: Formatting Worksheets
55
- Click the Format button. Excel displays the Format Cells dialog box.
- Click the Font tab, and choose the font and size that you want as the default.
- Click OK to return to the Style dialog box. Notice that the Font item displays the font
choice you made. - Click OK again to close the Style dialog box.
FIGURE 5.22
Use the Style dialog box to modify named styles.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.Creating new styles
In addition to using Excel’s built-in styles, you can create your own styles. This feature can
be quite handy because it enables you to apply your favorite formatting options quickly
and consistently.To create a new style, follow these steps:- Select a cell, and apply all the formatting that you want to include in the new
style. You can use any of the formatting that is available in the Format Cells dialog
box. - After you format the cell to your liking, choose Home ➪ Styles ➪ Cell Styles, and
choose New Cell Style. Excel displays its Style dialog box (refer to Figure 5.22),
along with a proposed generic name for the style. Note that Excel displays the
words By Example to indicate that it’s basing the style on the current cell.