Microsoft Office Tutorials and References
In Depth Information
A PPLY A F ORMAT S TYLE
Click and drag to select
the cells to which you
want to apply the style.
Click the Home tab.
Click Cell Styles.
The Style gallery
Click the style you
Excel applies the style.
Did You Know?
You can use the Format Painter to apply styles,
and you can copy, and paste formats from one cell
to another. However, if you use a format often,
consider creating a style. See Task # 71 to learn
more about Format Painter.
You can build a style from the ground up rather
than basing it on a formatted cell. Click the Home
tab and then click Cell Styles. The Style gallery
appears. Click New Cell Style and then in the Style
dialog box click Format. The Format cells dialog
box appears. You can use it to design your style.
Chapter 3: Copy, Format, and More