Excel 2010 Bible

Part I: Getting Started with Excel

132

Applying styles ........................................................................................................

Beginning with Excel 2007, the style feature has been revamped significantly, and Excel now

includes a good selection of predefined named styles that work in conjunction with document

themes. Figure 6.12 shows the effect of choosing Home ➪ Styles ➪ Cell Styles. Note that this dis-

play is a live preview: that is, as you move your mouse over the style choices, the selected cell or

range temporarily displays the style. When you see a style you like, click it to apply the style to the

selection.

Note
If Excel’s window is wide enough, you won’t see the Cell Styles command in the Ribbon. Rather, you will see
four or more formatted style boxes. Click the drop-down arrow to the right of these boxes to display all the
defined styles. n

FIGURE 6.12

Excel displays samples of available cell styles.

Note
By default, all cells use the Normal style. If you modify the Normal style, all cells that haven’t been assigned a
different style will reflect the new formatting. n

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

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:

l Modify an existing style.

l (^) Create a new style.
l Merge styles from another workbook into the active workbook.