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 Code To Filter By Wildcard String Pattern

    vba to filter by wildcard string pattern, filter by substring in excel, how to filter by wildcard string in excel, wildcard pattern matching in excel

    Share The Knowledge
  • Second Maximum Value In Excel

    A very common interview question that is asked in an excel interview is to find the second maximum value in a […]

    Share The Knowledge
  • Add Time To A DateTime Value In Excel

    add minute to a date time value in excel, add hour to a date time value in excel, add second to a date time value in excel, add time value to a datetime in excel
    ,excel formula to add time to a datetime value

    Share The Knowledge
  • Convert Date Into Week Number In VBA

    convert a date into week number in vba, how to get week number from today’s date, vba to convert date into week number, excel date to week number

    Share The Knowledge

Leave a Reply