Delete A PivotTable - Microsoft Support

Home » How To Delete Pivot Table » Delete A PivotTable - Microsoft Support

Maybe your like

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.

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

  3. Pick a cell anywhere on the PivotTable for the "Delete" option to appear. 

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 using PivotTables in Excel

  • Use PivotTables and other business intelligence tools to analyze your data

  • Create a PivotTable from worksheet data

  • Create a PivotTable from external data

  • Create a PivotTable to analyze data in multiple tables

  • Video: Create PivotTables

Tag » How To Delete Pivot Table