Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
2
Home tab
Cell Styles
button
Click the Cell Styles
button (Home tab |
Styles group) to
display the Cell Styles
gallery.
live preview of
Heading 3 cell style
in range A3:H3
Point to the Heading 3
Total cell style
Heading 3 cell style
cell style in the Titles
and Headings area of
the Cell Styles gallery
to see a live preview
of the cell style in
the selected range
(Figure 1– 42).
Titles and
Headings area
Figure 1– 42
I
Experiment
Point to other cell styles in the Titles and Headings area of the Cell Styles gallery to see a live
preview of other cell styles in the selected range, A3:H3.
3
Click the Heading 3
cell style to apply
the cell style to the
selected range.
button (Home tab |
Alignment group) to
center the column
headings in the
selected range.
Click the Center
Center button
Heading 3 cell
style applied to
range A3:H3
Click cell A9 and
range A9:H9
selected
then drag the mouse
pointer to cell H9
to select a range
(Figure 1– 43).
Figure 1– 43
Why should I choose Heading 3 instead of another heading cell style?
Excel includes many types of headings, such as Heading 1 and Heading 2, because worksheets
often include many levels of headings above columns. In the case of the worksheet created
for this project, the Heading 3 title includes formatting that makes the column titles’ font size
smaller than the title and subtitle and makes the column titles stand out from the data in the
body of the worksheet.
 
Search JabSto ::




Custom Search