Software & Apps MS Office How to Delete Pivot Table Delete pivot tables without losing your data By Daniel N. Martin Writer Daniel Martin is a writer and researcher with 10+ years' experience. He is a professional librarian and an experienced tech and information literacy teacher. our editorial process LinkedIn Daniel N. Martin Updated January 09, 2020 Aajan / Getty Images MS Office Excel Word Powerpoint Outlook Tweet Share Email Pivot Tables are very useful tools in Microsoft Excel that allow you to manipulate your data, including sorting, organizing, grouping, organizing, and totaling it. They also let you easily summarize the information from a more detailed worksheet. By dragging and dropping data into the Pivot Table, you can quickly and easily get all the relevant info you need. However, there are times when you need to know to delete a Pivot Table properly to review your worksheet or make changes to the data. The instructions in this article apply to Microsoft Excel 2019, Excel 2016, and Office 365. How to Delete a Pivot Table in Your Worksheet Once you've finished using your Excel Pivot Table, you can easily delete both the table itself and the summary created by the table. Select any cell in your Pivot Table. Navigate to the PivotTable Analyze section of the ribbon and choose Select. This section will only appear once you have selected cells in the Pivot Table. Select Entire Pivot Table to highlight the whole table. Press the Delete key to delete the Pivot Table. You can also just delete the entire worksheet, but that will also get rid of all of your other data as well. How to Delete the Pivot Table and Keep the Data Select any cell in your Pivot Table. Navigate to the PivotTable Analyze section of the ribbon and choose Select. Select Entire Pivot Table to highlight the whole table. Right-click any cell in the highlighted Pivot Table. Select Copy to copy all data from the Pivot Table, then select Paste > Paste Values from the drop-down Paste menu. Once the values are pasted, highlight the Pivot Table and hit the Delete key to delete the table. How to Delete the Data and Keep the Pivot Table You might find that once you have the data summary you need, it's easier for you to get rid of the data rather than create a new pivot table. This lets you review a new set of data without having to create a new Pivot Table. Select any cell in your Pivot Table. Navigate to the PivotTable Analyze section of the ribbon and choose Select. From the Actions section, select Clear > Clear All to clear the data without deleting your Pivot Table.