How to delete a pivot table in Excel
Sometimes a pivot table may become inactive or you may want to delete it for creating one from a different dataset. In excel this can be achieved in two ways.
- Method 1: Using keyboard selection
- Method 2: Using Select menu
Suppose we have a pivot table in our excel worksheet.
![](https://spreadcheaters.com/wp-content/uploads/Data-Set-How-to-delete-a-pivot-table-in-Excel-1024x439.png)
Method 1: Using keyboard selection
In this method we are going to use the keyboard shortcut to select and delete the pivot table.
Step 1 – Using keyboard to select pivot table
![](https://spreadcheaters.com/wp-content/uploads/Method-1-Step-1-Final-Image-How-to-delete-a-pivot-table-in-Excel.gif)
- Click anywhere inside the pivot table.
- Press the key combination ‘Ctrl + A’.
- Press the delete button on the keyboard.
- The pivot table will be deleted.
Method 2: Using Select menu
Step 1 – Click Entire PivotTable in Select menu
![](https://spreadcheaters.com/wp-content/uploads/Method-2-Step-1-Final-Image-How-to-delete-a-pivot-table-in-Excel.gif)
- Click anywhere in the pivot table.
- Go to PivotTable Analyze tab and find the Select drop down menu in the Actions group.
- On the menu click Entire PivotTable
- Press delete button to delete the pivot table.