How to Delete a Pivot Table in Excel – 3 Methods

This is the sample dataset.

how to delete a pivot table

This is the pivot table.


Method 1 – Delete the Pivot Table with the Data Table

Steps:

  • Select the table.  Here, B4:E9.

Delete Pivot Table with Table Data

  • Press Delete to delete the pivot table.

  • You can also go to the PivotTable Analysis tab and select the Entire Pivot Table in Select.
  • Press Delete.

Delete Pivot Table with Table Data


Method 2 – Delete the Pivot Table and keep the Data Table

Steps:

  • Select a cell in the pivot table report and go to the PivotTable Analyze tab.
  • Click Select and choose Entire Pivot_Table.

Delete Pivot Table without Table Data

  • Press Ctrl+C.
  • Select a cell to keep the data.
  • Press Ctrl+V.

  • Press Ctrl and choose Value in Paste Values.

You’ll see the pivot table raw data.

Delete Pivot Table without Table Data

  • Select the entire table.

Delete Pivot Table without Table Data

  • Press Delete..

Method 3 – Applying a VBA Code to Delete All Pivot Tables

Steps:

  • Press Alt+F11.
  • In the Microsoft Visual Basic for Application, click Insert and select Module.

Applying VBA Code to Delete All the Pivot Tables

  • Enter the following code.
Sub del_piv_table()
Dim w_s As Worksheet
Dim Piv_table As PivotTable
On Error Resume Next
For Each w_s In ActiveWorkbook.Worksheets
    For Each Piv_table In w_s.PivotTables
        w_s.Range(Piv_table.TableRange2.Address).Delete Shift:=xlUp
    Next Piv_table
Next w_s
End Sub

Applying VBA Code to Delete All the Pivot Tables

  • Click Run.


How to Move a Pivot Table in Excel

  • Select the pivot table and go to the PivotTable Analyze tab.

How to Move Pivot Table

  • Select Move PivotTable in Actions.
  • Select Existing worksheet to keep the table in the same worksheet.

  • Select a cell to place the table. Here, F4.
  • Click OK.

How to Move Pivot Table

This is the output.


How to Delete a Pivot Table Field in Excel

  • Select the pivot table and go to the PivotTable Analyze tab.
  • Click Field List in Show.

How to Delete a Pivot Table Field

  • Uncheck the field you want to delete. Here, Sum of Amount.

How to Delete a Pivot Table Field

This is the output.


Download Practice Workbook

Download the practice workbook.

Get FREE Advanced Excel Exercises with Solutions!
Kawser Ahmed
Kawser Ahmed

Kawser Ahmed is a Microsoft Excel Expert, Udemy Course Instructor, Data Analyst, Finance professional, and Chief Editor of ExcelDemy. He is the founder and CEO of SOFTEKO (a software and content marketing company). He has a B.Sc in Electrical and Electronics Engineering. As a Udemy instructor, he offers 8 acclaimed Excel courses, one selected for Udemy Business. A devoted MS Excel enthusiast, Kawser has contributed over 200 articles and reviewed thousands more. His expertise extends to Data Analysis,... Read Full Bio

5 Comments
  1. thank sir

  2. Always very helpful and useful lessons . Thanks you!!!

  3. sometimes simple things are the biggest problems…super sir, thanks

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo