Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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.

  1. Click the PivotTable or PivotChart.

  2. On the Analyze tab, in the Actions 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.

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 Communities.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×