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

Applies To: Excel 2013



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language