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:
- Click anywhere within the PivotTable to show the PivotTable Tools on the ribbon.
- Click Analyze, Select, and then pick Entire PivotTable.
- Press Delete.