Modify a PivotTable Report : PivotTable « PivotTable PivotChart « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. PivotTable PivotChart
3. PivotTable

Click any field in the PivotTable report. 
           Click the Options tab under PivotTable Tools.

To change PivotTable options, click the Options button

Make the changes and then click OK.

To change field settings, select the field, 
           click the Field Settings button

Then Make the changes and then click OK.

9.2.PivotTable
	9.2.1.	Create a PivotTable or PivotChart Report
	9.2.2.	Delete a PivotTable.
	9.2.3.	Add or Remove a Field in a PivotTable or PivotChart Report
	9.2.4.	Modify a PivotTable Report
	9.2.5.	Format a PivotTable Report
	9.2.6.	Select a different data source for a PivotTable
	9.2.7.	Refresh PivotTable
	9.2.8.	Rename a PivotTable
	9.2.9.	Rename a field in a PivotTable