How to Delete a Pivot Table in Excel

puneet-gogia-excel-champs-09-06-23

- by Puneet

Steps to Delete a Pivot Table in Excel

Use the following steps to delete a pivot table.

  1. First, click anywhere on the pivot table you want to delete and activate the analyze tab.
    activate-analyze-tab
  2. Now, look for the option “Select” under “Actions”.
    select-under-actions
  3. After this, click on the little drop-down to select “Entire PivotTable”.
    select-entire-pivot-table
  4. As a result, your entire pivot able will be selected.
  5. In the end, press the delete key on the top right corner of your keyboard.

Reset the pivot table

Just follow the below quick steps to reset all the fields of a pivot table.

  1. First, click anywhere on the pivot table.
  2. Now, go to the analyze tab.
    go-to-analyze-tab
  3. Here click on the little button next to clear.
    little-button-next-to-clear
  4. At last, click on “Clear All”.
    click-on-clear-all

As a result, you will get a blank pivot table. All the rows and column values will be reset.