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

  • VBA To Open Latest Excel Workbook

    vba to open latest excel workbook in a folder, how to open most recent file from a folder in excel vba, open latest file from folder in excel vba, open most recent workbook in excel, code to open the most recent file from a folder in vba

    Share The Knowledge
  • Excel Average Formula Excluding 0/Zero

    In this post we will see how could we calculate average in excel while excluding 0’s. We will explain the […]

    Share The Knowledge
  • Set Size Of Excel Sheet To A4 and A3

    To make the excel printer friendly, we could manipulate the size of the excel sheet to fit our requirements. We […]

    Share The Knowledge
  • Remove Column Headers/Row Headers In Excel

    Column headers are the alphabetical character which is displayed in the column header and row headers are the numeric digit […]

    Share The Knowledge

Leave a Reply