Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet EX 35
To Change a Cell Style
Excel includes the capability of changing several characteristics of a cell, such as font type, font size, and font
color, all at once by assigning a predefi ned cell style to a cell. The following steps assign the Title cell style to the
worksheet title in cell A1.
1
Click cell A1 to make
cell A1 the active cell.
Cell Styles
button
Home tab
active
Click the Cell Styles
button on the Ribbon
to display the
Cell Styles
gallery
(Figure 1–47).
A1 is
active cell
Cell Styles
gallery
Figure 1–47
2
Point to the Title cell
style in the Titles and
Headings area of the
Cell Styles gallery to
see a live preview of
the cell style in cell A1
(Figure 1–48).
I
live preview of
Title cell style
in cell A1
Title cell
style
Experiment
Point to several other
cell styles in the Cell
Styles gallery to see a
live preview of other
cell styles in cell A1.
Titles and
Headings area
Why does the font
type, font size, and
font color change in
cell A1 when I point
to it?
The change in cell A1
is a result of live
preview. Live preview
is a feature of Excel
2007 that allows you
to preview cell styles
as you point to them in the Cell
Styles gallery.
Figure 1–48
Search JabSto ::




Custom Search