2007 Microsoft® Office System Step by Step, Second Edition

Defining Styles

As you work with Excel 2007, you will probably develop preferred formats for data labels, titles, and other worksheet elements. Instead of adding the format’s characteristics one element at a time to the target cells, you can have Excel 2007 store the format and recall it as needed. You can find the predefined formats available to you by displaying the Home tab, and then in the Styles group, clicking Cell Styles.

Clicking a style from the Cell Styles gallery applies the style to the selected cells, but Excel 2007 goes a step beyond previous versions of the program by displaying a live preview of a format when you hover your mouse ...