how to delete pivot table

After Creating Pivot Table and using it to create reports, you may want to delete it. You will find below the steps to delete Pivot Table in Excel in three different scenarios.

Delete Pivot Table in Excel

The quickest way to Delete Pivot Table in Excel is to delete the worksheet containing the Pivot Table.

Right-click on the worksheet having Pivot Table and click on the Delete option in the right-click menu that appears.

Manually Delete Worksheet in Excel

Another way to delete Pivot Table in Excel is to select any Cell in the Pivot Table and use Control + A Keyboard Shortcut.

However, both these options select only the visible cells in Pivot Table and cannot be used if filters are applied in the Pivot Table.

Also, above methods cannot be used if you want to delete the Pivot Table while retaining the resulting summary created by the Pivot Table.

Hence, we are providing below the steps to Delete Pivot Table along with its data, Delete Pivot Table while keeping its data and also the steps to Delete Pivot Table data while retaining the Pivot Table.

1. Delete Pivot Table Along With its Data

Follow the steps below to Delete Pivot Table along with all its data.

1. Select any Cell in the Pivot Table.

2. Click on the PivotTable Analyze tab in the top menu bar > click on Actions > Select > Entire PivotTable.

Select Entire Pivot Table Option in Excel

Note: PivotTable Analyze tab appears only when you select any cell within the Pivot Table.

3. Once the Entire Pivot Table is selected, hit the Delete key on the keyboard of your computer to delete the Pivot Table along with its resulting data.

2. Copy Pivot Table Data and Delete Pivot Table

This is a common situation that arises when you want to send only the summary or the resulting data generated by a Pivot Table and not include the Pivot Table in your submission.

1. Select any Cell in the Pivot Table.

2. Click on the PivotTable Analyze tab in the top menu bar > click on Actions > Select > Entire PivotTable.

Select Entire Pivot Table Option in Excel

3. With entire Pivot Table selected, right-click on any Cell of the Pivot Table and click on Copy.

Copy Pivot Table Data

4. Next, right-click on an empty Cell in the worksheet and click on the Paste Special option.

Paste Pivot Table Data

Note: You can also paste Pivot Table data on a New Worksheet.

5. On Paste Special Dialogue box, select the Values option and click on OK.

Paste Special Dialogue Box in Excel

6. As you can see below, only the Summary or the resulting data created by Pivot Table has been pasted.

Copy Pivot Table Data in Same Worksheet

After pasting Pivot Table data, you can delete the Pivot Table by repeating the steps to select the Entire Pivot Table and pressing the Delete button.

3. Delete Pivot Table Data but Keep Pivot Table

In this case, you are trying remove the Summary or resulting data created by the Pivot Table, while still retaining the Pivot Table for reuse.

1. Select any Cell in the Pivot Table.

2. Click on the PivotTable Analyze tab in top menu bar > click on Actions > Clear > Clear All.

Clear All Pivot Table Data

3. This will totally clear the resulting data created by Pivot Table and you will end up with a blank Pivot Table.

You can reuse the Blank Pivot Table to build another report and analyze data in some other way.

How to Create Pivot Table From Multiple Worksheets
How to Add or Remove Subtotals in Pivot Table
How to Change Pivot Table Data Source and Range