Delete a PivotTable

When you no longer need a PivotTable, select the entire PivotTable, and then press Delete to remove it.

If your PivotTable is too large to select, you can remove it like this:

  1. Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.

PivotTable Tools

  1. Click Analyze > Select, and then pick Entire PivotTable.

Select button on the Analyze tab of the PivotTable Tools

  1. Press Delete.

 Tip    If your PivotTable is on a separate sheet that has no other data you want to keep, deleting that sheet is a fast way to remove the PivotTable.

More about PivotTables

Applies to:
Excel 2013