Microsoft Office Tutorials and References
In Depth Information
To Use the Total Row Check Box
To Use the Total Row Check Box
The Total Row check box on the Design tab allows you to insert a row at the bottom of the table called the
total row . Within the total row, it sums the values in the far-right column of the table, if the values are numeric. If
the values in the far-right column of the table are text, then Excel counts the number of records. For example, in
Figure 5–30 on the next page, the 13 in cell J22 on the right side of the total row is a count of the number of sales
rep records. Excel provides additional computations for the total row, as shown in the following steps.
1
Select cell A9 to
make the table
active and then
click the Design
tab on the Ribbon
(Figure 5–29).
I
Design tab
Header
Row
check box
Banded
Columns
check box
Total
Row
check box
Experiment
Select a variety of
combinations of
check boxes in the
Table Styles Options
group on the Design
tab on the Ribbon.
When fi nished, make
sure that the check
boxes are set as
shown in Figure 5–29.
cell A9
selected
Figure 5–29
 
 
Search JabSto ::




Custom Search