Delete a PivotTable

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

If you get a "Cannot change this part of a PivotTable report" message, make sure the entire PivotTable is selected. Press Ctrl+A, and press Delete again.

If you're using a device that doesn't have a keyboard, try removing the PivotTable like this:

  1. Pick a cell anywhere in the PivotTable to show the PivotTable Tools on the ribbon.
    Select Entire PivotTable

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

  3. 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

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×