EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Login
Home Excel Excel Resources Excel Tips Excel Delete Pivot Table

Excel Delete Pivot Table

Jeevan A Y
Article byJeevan A Y
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated August 16, 2023

Delete Pivot Table in Excel

Excel Delete Pivot Table (Table of Contents)
  • Delete Pivot Table in Excel
  • How to Delete a Pivot Table in Excel?

Delete Pivot Table in Excel

To delete any pivot table in Excel, select the pivot table first. This will activate the Design and Analyze menu tabs. Go to Analyze menu tab; from the drop-down of the Select option, select Entire Pivot Table. This will select the entire pivot table data, whereas if you press Ctrl + A, which will not work on Pivot Table. Now simply press Delete or select Delete from the right-click menu list to delete the pivot table.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

We usually see the default pivot table, as shown in the below image.

Delete pivot table

According to our wish, a typical pivot table includes Pivot Table Fields to drag and drop the data headings to our fields. Typically, we can remove the Excel pivot table from the worksheet in two ways. Follow this article to learn one by one.

I will start by applying the pivot table. You can download this workbook to practice along with me to get practical experience on the go. I have sales data country-wise, which includes many other fields, but I am considering only two columns, i.e., Country and Units Sold.

Delete Pivot Table Step 1-1

Data is there from the range A1 to H701. I need to summarise the data, what are the total units sold by country-wise. Let us start the process of applying a pivot table.

  • Select the entire data to the range, i.e., A1:H701.
  • Go to Insert and click on the Pivot Table.

Delete Pivot Table Step 1-2

  • Once you click on this, it will insert a new worksheet.

Delete Pivot Table Step 1-3

  • Drag and drop Country heading to ROWS and Units sold to VALUES.

Delete Pivot Table Step 1-4

  • Now your summary should be like this.

Result

How to Delete a Pivot Table in Excel?

It is very simple and easy to use. Let us understand the working of Deleting the Pivot Table in Excel by some Methods.

You can download this Delete Pivot Table Excel Template here – Delete Pivot Table Excel Template

Method #1 – Remove the Pivot table by copying and Pasting as Values

Now I can remove or delete the Excel pivot table in two ways.

Step 1: Select the pivot table range.

Delete Pivot Table Step 2

Step 1.1: We can select the pivot table like this also. Place a cursor inside the pivot table > Go to Options > Select > Entire Pivot Table.

Select Entire Pivot Table

Step 2: Press Ctrl + C to copy the data once the pivot table is selected.

Press Ctrl + C

Step 3: Do not change your cursor once you copy the pivot table. Press ALT + E + S; this would instantly open up the Paste Special dialogue box. Select Values from here and Click Ok.

Select Values

Step 4: Now, pivot table data is pasted as values. An Excel pivot table is removed.

Delete Pivot Table Step 2-4

If you observe all the formatting like background color, font style, font name, and even the pivot table fields are removed from the list in Excel.

Method #2 – Remove the pivot table by using Clear Option

Step 1: Select the pivot table range.

Delete Pivot Table Step 3

Step 1.1: We can select the pivot table like this also. Place a cursor inside the pivot table > Go to Options> Select > Entire Pivot Table.

Delete Pivot Table Step 3-1

Step 2: Once you have selected the pivot table range, click the delete option to delete or remove the Excel pivot table.

Step 2.1: Once you have selected the pivot table range, go to Options > Clear > Clear All.

Delete Pivot Table Step 3-2

This will remove only the existing pivot table fields, but the sheet with pivot table options to drag and drop remains the same.

Delete Pivot Table Step 3-3

Ok, we can remove the Excel pivot table in these two methods.

Method #3 – Delete All Pivot Tables in One Shot

We have learned the easy way of removing or deleting the pivot table in Excel. But the problem is deleting many pivot tables in a workbook is not that easy.

We need the VBA code to remove the pivot table. I have already written the VBA code to delete all the existing pivot tables in the workbook.

Copy and paste the below code to your VBA module and save the workbook as a macro-enabled workbook.

Sub DeleteAllPivotTables()
Dim Wb As Workbook, Ws As Worksheet, Pt As PivotTable
If MsgBox(“Do you want to delete all the pivot tables?”, _
vbYesNo + vbDefaultButton2, “DELETE ALL?”) = vbNo Then Exit Sub
On Error Resume Next
For Each Ws In ActiveWorkbook.Worksheets
For Each Pt In Ws.PivotTables
Ws.Range(Pt.TableRange2.Address).Delete Shift:=xlUp
Next Pt
Next Ws
End Sub

Step 1: Open the VBA editor by pressing ALT + F11.

VBA editor

Step 2: Go to Insert > Module.

Module

Step 3: Once the module is inserted, copy and paste the above code and save the workbook as a macro-enabled workbook.

Copy and paste code

Things to Remember

  • We can remove the Excel pivot table and pivot worksheet as well.
  • Once the Excel pivot table is removed using VBA code, we cannot undo the action, so it is safe to have a backup copy.
  • Once the Excel pivot table is removed, any changes in the database will not reflect on the removed field.

Recommended Articles

This has been a guide to Delete Pivot Table in Excel. Here we discuss how to Delete or Remove the Pivot Table in Excel with three different Methods and a downloadable Excel template. You can also go through our other suggested articles –

  1. Pivot Table Formula in Excel
  2. Excel Pivot Chart
  3. Excel Conditional Formatting in Pivot Table
  4. VBA Refresh Pivot Table
ADVERTISEMENT
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
Financial Analyst Masters Training Program
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
All in One Data Science Bundle
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
All in One Software Development Bundle
5000+ Hours of HD Videos
149 Learning Paths
1050+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Delete Pivot Table Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Delete Pivot Table Excel Template

EDUCBA

डाउनलोड Delete Pivot Table Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Extended Cyber Monday Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW