Microsoft Office Tutorials and References
In Depth Information
Editing PivotTables
Excel displays the PivotTable name when you click the PivotTable button on the Analyze
tool tab. 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 tool tab, in the PivotTable Options group, enter the new name in
the PivotTable Name field.
When you create a PivotTable with at least one field in the Rows area and one field in the
Columns area of the PivotTable Fields 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 tool 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