A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.
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:
Pick a cell anywhere in the PivotTable to show the PivotTable Tools on the ribbon.
Click PivotTable Analyze > Select, and then pick Entire PivotTable.
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
1. Right click on a cell anywhere in the PivotTable to show the context menu.
2. Pick Delete PivotTable.
You can also select the entire PivotTable (CTRL + A) and press Delete on your keyboard.
If your PivotTable is on a separate sheet that has no other data you want to keep, right-click the sheet tab and click Delete:
More about using PivotTables in Excel for the web
PivotTable on iPad is gradually rolling out to customers running Excel on iPad version 2.80.1203.0 and above.
To remove a PivotTable from your workbook, select the entire PivotTable and press the delete key on your keyboard.
To display the keyboard on your iPad, tap a cell outside of the PivotTable range, and then tap the formula bar at the top of the worksheet area:
If your PivotTable is on a separate sheet that has no other data you want to keep, tap the sheet tab at the bottom of the screen and select Delete:
You can also delete the rows or columns spanning the entire range of your PivotTable if they don’t contain other data you want to keep: