how to remove subtotals from pivot table macro excel 365

The above steps would delete the Pivot Table. In the Actions group, click on the ‘Select’ option.

This is a contextual tab that appears only when you have selected any cell in the Pivot Table.

Click on the ‘Analyze’ tab in the ribbon.

Delete the Pivot Table and the Resulting Dataīelow is an example where I have created a Pivot table and used it to get the Sum of Revenue for different regions (to which I will be referring to as Pivot Table summary data in this tutorial).īelow are the steps to delete the Pivot table as well as any summary data: Let’s dive in and see each of these methods.

Delete the resulting data but keep the Pivot Table.

Delete the Pivot Table but keep the resulting data.

Delete the Pivot Table & the resulting data (the summary created using the Pivot Table).

The method you choose will depend on how you want to delete the Pivot Table.īelow are some scenarios that I will be covering in this tutorial: When it comes to deleting a Pivot Table, there are a few different ways you can do this. Since you’re reading a tutorial about removing or deleting a Pivot Table, I am assuming you already have a Pivot Table(s) in place that you want to remove. Delete the Resulting Data but Keep the Pivot Table.Delete the Pivot Table but Keep the Resulting Data.Delete the Pivot Table and the Resulting Data.

How to remove subtotals from pivot table macro excel 365