Delete a pivottable

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

Windows Web



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

To remove a PivotTable from your workbook in Excel for the web, select the entire PivotTable and 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 click Delete.

More about using PivotTables in Excel for the web

• Create a PivotTable

• Use the Field List to arrange fields in a PivotTable

• Sort data in a PivotTable

• Refresh PivotTable data

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.