Microsoft Office Tutorials and References
In Depth Information
Adding Totals and Formulas to a Table
CAUTION !
If your table contains a Total row and you move the sizing handle up to remove rows
that currently contain data, you create a circular reference. To avoid this, first delete (or
move) the contents of any cells that you plan to remove from the table range.
You can add a reference to any table by using its name, as defined in the Table Name box
in the Properties group on the Design tab. The range defined by this name automatically
expands when you add rows or columns to the table. (It does not, however, include the
Header and Total rows.) If you use the current table as the basis for a PivotTable, any new
rows or columns you create are automatically available for use in the PivotTable. Likewise,
when you use data from rows or columns in a table to define data series, labels, or other
elements in a chart, those elements are automatically updated when you expand the table.
Adding Totals and Formulas to a Table
When you create a table, Excel allows you to perform a few tricks with formulas that aren’t
available within a normal range. The most obvious is the Total row, which you can use
to quickly add summaries of table data. As we explained earlier in this chapter, you can
manually enable the Total row by selecting its check box in the Table Styles Options group
on the Design tab.
Figure 12-4 shows the Total row for a table containing sales results. Note that Excel
automatically added a formula that totals the rightmost column in the table.
Figure 12-4 Excel uses its own internal logic to decide which columns are summarized in the
Total row. You can add or change these formulas with a few clicks.
Search JabSto ::




Custom Search