Microsoft Office Tutorials and References
In Depth Information
EX 42
Excel Chapter 1 Creating a Worksheet and an Embedded Chart
To Format Column Titles and the Total Row
The next step to format the worksheet is to format the column titles in row 3 and the total row, row 9. Column
titles and the total row should be formatted so anyone who views the worksheet can quickly distinguish the column
titles and total row from the data in the body of the worksheet. The following steps format the column titles and total
row using cell styles in the default worksheet theme.
1
Click cell A3 and
then drag the mouse
pointer to cell G3 to
select the range A3:G3.
Cell Styles
button
Point to the Cell Styles
button on the Ribbon
(Figure 1–61).
Why is cell A3 selected
in the range for the
column headings?
The style to be applied
to the column
headings includes an
underline that will help to
distinguish the column
headings from the rest
of the worksheet.
Including cell A3 in the range
ensures that the cell will include the underline, which is visually appealing and further helps to
separate the data in the worksheet.
range
A3:G3
selected
Figure 1–61
2
Click the Cell Styles
button to display the
Cell Styles gallery.
Point to the
Heading 3 cell style
in the Titles and
Headings area of the
Cell Styles gallery to
see a live preview of
the cell style in the
range A3:G3
(Figure 1–62).
I
Heading 3
cell style
Total cell
style
live preview
of Heading
3 cell style in
range A3:G3
Titles and
Headings area
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
range A3:G3.
Figure 1–62
Search JabSto ::




Custom Search