Microsoft Office Tutorials and References
In Depth Information
Excel displays the PivotTable name on the Options contextual tab, in the PivotTable
Options group. The name PivotTable2 doesn’t help you or your colleagues understand
the data the PivotTable contains, particularly if you use the PivotTable data in a formula
on another worksheet. To give your PivotTable a more descriptive name, click any cell in
the PivotTable and then, on the Options contextual tab, in the PivotTable Options group,
type the new name in the PivotTable Name field.
When you create a PivotTable with at least one field in the Row Labels area and one field
in the Column Labels area of the PivotTable Field List task pane, Excel adds a grand total
row and column to summarize your data. You can control how and where these
summary rows and columns appear by clicking any PivotTable cell and then, on the Design
contextual tab, in the Layout group, clicking either the Subtotals or Grand Totals button
and selecting the desired layout.
After you create a PivotTable, Excel determines the best way to summarize the data in the
column you assign to the Values area. For numeric data, for example, Excel uses the SUM
function. If you want to change a PivotTable summary function, right-click any data cell in
the PivotTable values area, point to Summarize Values By, and then click the desired
operation. If you want to use a function other than those listed, click More Options to display the
Value Field Settings dialog box. On the Summarize Values By page of the dialog box, you
can choose the summary operation you want to use.
Search JabSto ::

Custom Search