Delete/Remove Pivot Table In Excel

Let’s see how to delete a pivot table in an excel sheet.

Sometimes we want to delete the existing pivot table in the excel sheet because we either want to create a new pivot table with major layout changes.

We will see a simple example as to how to delete a pivot table.

Step 1

Click on the pivot table that you want to delete and go to Analyze->Select->->Entire Pivot Table to select the entire pivot table.

Capture

Step 2

While you pivot table is selected go to Home->Clear->Clear All to delete the pivot table.




You could alternatively use keyboard shortcut Alt+E+A+A to delete the pivot table selected.

Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply