How to Delete Pivot Tables in Excel

This article explains how to delete pivot tables, which sort, organize, and summarize your data, in Microsoft Excel. Instructions cover Excel 2019, Excel 2016, and Microsoft 365.

How to Delete a Pivot Table in Your Worksheet

Follow these steps to delete both the table itself and the summary created by the table.

1. Select any cell in your pivot table, then select PivotTable Analyze in the ribbon.

2. Click Select > Entire Pivot Table to highlight the whole table.

3. Press the Delete key to delete the pivot table.

How to Delete the Pivot Table and Keep the Data

Follow these steps if you want to delete a pivot table but keep the data within it.

1. Select any cell in your pivot table, then select PivotTable Analyze in the ribbon.

2. Click Select > Entire Pivot Table to highlight the whole table.

3. Right-click any cell in the highlighted pivot table and select Copy.

4. Go to Paste > Paste Values to paste the data into the worksheet.

5. Highlight the pivot table again and press Delete to remove the table.

How to Delete the Data and Keep the Pivot Table

Once you have the data summary you need, you can clear all of the data so that you can review a new set of data without having to create a new pivot table.

1. Select any cell in your pivot table, then select PivotTable Analyze in the ribbon.

2. Click Select > Entire Pivot Table to highlight the whole table.

3. Click Clear > Clear All to clear the data without deleting your pivot table.