We can delete the pivot table in Excel in four ways:
- Remove the pivot table completely
- Delete pivot table data but Keep the Pivot Table
- Delete pivot table but its data remains
- Delete all pivot tables in the entire workbook
In the following article, we will examine every 4 methods.
How to remove the pivot table completely
- Open the student.xlsx spreadsheet.
2. Create a pivot table in excel.
3. Select any cell in the Pivot Table (for example A4).
4. In the PivotTable Analyze Tab.
5. Choose Select .
6. Select Entire pivotTable.
7. Finally Hit the Delete key.
How to delete pivot table data but Keep the Pivot Table
- Open the student.xlsx spreadsheet.
2. Create a pivot table in excel.
3. Select any cell in the Pivot Table (for example B5).
4. In the PivotTable Analyze Tab.
5. Select Clear.
6. Select Clear All.
How to delete pivot table but its data remains
- Open the student.xlsx spreadsheet.
2. Create a pivot table in excel.
3. Select any cell in the Pivot Table (for example B5).
4. From the PivotTable Analyze Tab.
5. Choose Select .
6. Select Entire pivotTable.
7. copy PivotTable (press Ctrl/cmd +C).
8. In the Home Tab.
9. Select Paste.
10. Select Paste Value.
Delete all pivot tables in all sheets (VBA CODE)
- Press (ALT+F11) to open Microsoft Visual Basic for Applications.
- Select the Insert Tab.
- Choose Module.
- Paste the following code in the module window:
Sub ClearPivotTables()
Dim Ws As Worksheet, Pt As PivotTable
On Error Resume Next
For Each Ws In ActiveWorkbook.Worksheets
For Each Pt In Ws.PivotTables
Pt.TableRange2.Clear
Next Pt
Next Ws
End Sub5. Press F5 to run the macro.
6. In the macro window, Select Run.
