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.

What to Know

  • Select a cell in the pivot table and click PivotTable Analyze. Click Select > Entire Pivot Table and press Delete to delete the pivot table.Keep the data: Select a cell and click PivotTable Analyze. Highlight the table, right-click a cell, select Copy, and go to Paste > Paste Values.Delete only the data: Select a cell and click PivotTable Analyze. Highlight the table and click Clear > Clear All to keep only the table.

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.

  • Select any cell in your pivot table, then select PivotTable Analyze in the ribbon.
  • Click Select > Entire Pivot Table to highlight the whole table.
  • 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.

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

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

Press the Delete key to delete the pivot table.

  • Select any cell in your pivot table, then select PivotTable Analyze in the ribbon.
  • Click Select > Entire Pivot Table to highlight the whole table.
  • Right-click any cell in the highlighted pivot table and select Copy.
  • Go to Paste > Paste Values to paste the data into the worksheet.
  • 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.

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

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

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

  • Select any cell in your pivot table, then select PivotTable Analyze in the ribbon.
  • Click Select > Entire Pivot Table to highlight the whole table.
  • Click Clear > Clear All to clear the data without deleting your pivot table.

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

Get the Latest Tech News Delivered Every Day