How to Delete Pivot Table

Delete pivot tables without losing your data

Excel Worksheet With Data

Aajan/Getty Images

Pivot Tables are very useful tools in Microsoft Excel that allow you to manipulate your data, including sorting, organizing, grouping, organizing, and totaling it. They also let you easily summarize the information from a more detailed worksheet. By dragging and dropping data into the Pivot Table, you can quickly and easily get all the relevant info you need.

However, there are times when you need to know to delete a Pivot Table properly to review your worksheet or make changes to the data.

The instructions in this article apply to Microsoft Excel 2019, Excel 2016, and Office 365.

How to Delete a Pivot Table in Your Worksheet

Once you've finished using your Excel Pivot Table, you can easily delete both the table itself and the summary created by the table.

  1. Select any cell in your Pivot Table.

    Selected Cell in Pivot Table
  2. Navigate to the PivotTable Analyze section of the ribbon and choose Select.

    PivotTable Analyze

    This section will only appear once you have selected cells in the Pivot Table.

  3. Select Entire Pivot Table to highlight the whole table.

    Entire PivotTable Button
  4. Press the Delete key to delete the Pivot Table. You can also just delete the entire worksheet, but that will also get rid of all of your other data as well.

How to Delete the Pivot Table and Keep the Data

  1. Select any cell in your Pivot Table.

    Selected Cell in Pivot Table
  2. Navigate to the PivotTable Analyze section of the ribbon and choose Select.

    PivotTable Analyze
  3. Select Entire Pivot Table to highlight the whole table.

    Entire PivotTable Button
  4. Right-click any cell in the highlighted Pivot Table.

  5. Select Copy to copy all data from the Pivot Table, then select Paste > Paste Values from the drop-down Paste menu.

    Paste Data Values
  6. Once the values are pasted, highlight the Pivot Table and hit the Delete key to delete the table.

How to Delete the Data and Keep the Pivot Table

You might find that once you have the data summary you need, it's easier for you to get rid of the data rather than create a new pivot table. This lets you review a new set of data without having to create a new Pivot Table.

  1. Select any cell in your Pivot Table.

    Selected Cell in Pivot Table
  2. Navigate to the PivotTable Analyze section of the ribbon and choose Select.

    PivotTable Analyze
  3. From the Actions section, select Clear > Clear All to clear the data without deleting your Pivot Table.

    Clear All Button