PivotTable Tools Tab
PivotTable toolbar is a collection of icons for commands required in configuring PivotTables and using the PivotTable wizard.
More Information
PivotTable Tools Tab
PivotTable
PivotTable Name |
Assign a name to the selected PivotTable. |
Options |
Specify the name and display method for a PivotTable. |
Active Field
Active Field |
Specify a name for the selected field. |
Field Settings |
Specify the name and the Summarize Value field by in subtotals or in data areas. |
Summary Function |
Change the summary function. 11 functions are available. |
Group
Group Selection |
Group some fields in a row or column area. |
Ungroup |
Ungroup the grouped fields in a row or column area. |
Group Field |
Split dates or numbers at specific intervals to group data that fit the criteria. |
Sort
Sort A to Z |
Sort the data in ascending order. |
Sort Z to A |
Sort the data in descending order. |
Sort |
Set sort direction and criteria to sort data. |
Data
Refresh |
Reflect the updated data to PivotTable if the source data has changed. |
View Source Data |
Create a new worksheet and show the row that the selected cell belongs to in a source data. |
Show
Field List |
Show or hide the field list of the task pane. |
Layout
Report Layout |
Set the layout of the selected PivotTable.
- Show in Compact Form: Compress the data area to its minimum size.
- Show in Outline Form: Display the data in basic PivotTable style format.
- Show in Tabular Form: Display the data in normal table format.
|
Show
Calculate |
Perform various calculations by referring to the original data. |
See Also
Toolbar, Customize, PivotTable