How to Delete Pivot Table

Delete pivot tables in Excel without losing your data

Pivot tables are useful for sorting, organizing, and summarizing your data in Microsoft Excel. This article explains how to delete a pivot table in 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.

    PivotTable Analyze in Excel 2019
  2. Click Select > Entire Pivot Table to highlight the whole table.

    Entire Pivot Table in Excel 2019
  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.

    PivotTable Analyze in Excel 2019
  2. Click Select > Entire Pivot Table to highlight the whole table.

    Entire Pivot Table in Excel 2019
  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.

    Paste Values in Excel 2019
  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.

    PivotTable Analyze in Excel 2019
  2. Click Select > Entire Pivot Table to highlight the whole table.

    Entire Pivot Table in Excel 2019
  3. Click Clear > Clear All to clear the data without deleting your pivot table.

    Clear All in Excel 2019
Was this page helpful?