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.
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.
Hope this helped.