Delete a PivotTable

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

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

1. Select a cell anywhere in the PivotTable to show PivotTable Tools on the ribbon.
2. Select PivotTable Analyze > Select > Entire PivotTable.
3. Select a cell anywhere in the PivotTable for the Delete option to appear.

More about using PivotTables in Excel

• Use PivotTables and other business intelligence tools to analyze your data
• Create a PivotTable to analyze worksheet data
• Create a PivotTable with an external data source
• Create a PivotTable to analyze data in multiple tables
• Video: Create PivotTables

1. Right-click a cell anywhere in the PivotTable to show the context menu.

2. Select Delete PivotTable.

You can also select the entire PivotTable by pressing Ctrl+A, and then press Delete.

If your PivotTable is on a separate sheet that has no other data you want to keep, right-click the sheet tab and select Delete:

More about using PivotTables in Excel for the web

• Create a PivotTable to analyze worksheet data
• Use the Field List to arrange fields in a PivotTable
• Sort data in a PivotTable or PivotChart
• Refresh PivotTable data

To remove a PivotTable from your workbook:

1. Tap and hold a cell anywhere in the PivotTable to show the context menu.

   

2. Tap Delete PivotTable.

You can also select the entire PivotTable and press Delete on your keyboard.

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 that span the entire PivotTable range if they don't contain other data you want to keep: