Delete a PivotTable in Excel

If you have ever struggled with deleting a PivotTable in Excel, then you have come to the right place.  We use Excel for all kinds of things.  Once in a while, we like to do a bit of house cleaning.  We recently published an article on how to export all of your worksheets within an Excel Workbook to CSV.  Well, in order for that to be useful, you can’t have a bunch of extraneous information running around your worksheets, like PivotTables.

Removing a PivotTable isn’t as straight forward as you would think… it isn’t as simple as highlighting it and hitting delete.  It isn’t difficult either, you just have to do it the way Microsoft wants you to.

To remove a PivotTable:

  1. Click anywhere within the PivotTable to show the PivotTable Tools on the ribbon.
    PivotTable-delete (1)
  2. Click Analyze, Select, and then pick Entire PivotTable.
    PivotTable-delete (2)
  3. Press Delete.

Enjoy!

About Joe D

I have always had a passion for everything computing. In early 2000, I decided to take my passion to the web. Thus, C.O.D. was born. Through the years we have made many great friends at C.O.D. and hope to continue our journey for years to come.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.