Clear a pivottable or pivotchart

To remove all report filters, labels, values, and formatting from a PivotTable, and to start designing the layout all over again, use the Clear All command.

Newer versions Office 2007 – 2010



1. Click the PivotTable or PivotChart.

2. On the Analyze tab, in the Actions group, click Clear, and then click Clear All.

Clear a PivotTable

1. Click the PivotTable.

2. On the Options tab, in the Actions group, click Clear, and then click Clear All.

Clear a PivotChart

1. Click the PivotChart.

2. On the Analyze tab, in the Data group, click Clear, and then click Clear All.

   The Clear All command resets your PivotTable, but does not delete it. The data connection, placement of the PivotTable, and PivotTable cache remain the same. If there is a PivotChart associated with the PivotTable, the Clear All command also removes related PivotChart fields, chart customizations, and formatting.

The Clear All command resets your PivotTable, but does not delete it. The data connection, placement of the PivotTable, and PivotTable cache remain the same. If there is a PivotChart associated with the PivotTable, the Clear All command also removes related PivotChart fields, chart customizations, and formatting.

Note: If you are sharing a data connection or if you are using the same data between two or more PivotTable, then using the Clear All command on one PivotTable could also remove the grouping, calculated fields or items, and custom items in the other shared PivotTables. However, you are warned before Excel attempts to remove items in the other shared PivotTables, and you can cancel the operation.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.