There may be cases when you want to delete the Pivot table, but not the resulting data that you have got after using the Pivot table. Delete the Pivot Table but Keep the Resulting Data Of course, you wouldn’t want to do this if you have any other data in the worksheet. You need to use the method shown above (or select the Pivot Table manually)Īnother quick way to delete the Pivot Table is to simply delete the worksheet that has the Pivot Table. In case you have filters applied in the Pivot table, Control A will not select the entire Pivot Table. Note that you can also select the entire Pivot Table by selecting any cell and then using the keyboard shortcut ‘ Control + A‘. The above steps would delete the Pivot Table. In the Actions group, click on the ‘Select’ option.This is a contextual tab that appears only when you have selected any cell in the Pivot Table. Click on the ‘Analyze’ tab in the ribbon.Delete the Pivot Table and the Resulting Dataīelow is an example where I have created a Pivot table and used it to get the Sum of Revenue for different regions (to which I will be referring to as Pivot Table summary data in this tutorial).īelow are the steps to delete the Pivot table as well as any summary data: Let’s dive in and see each of these methods. Delete the resulting data but keep the Pivot Table.Delete the Pivot Table but keep the resulting data.Delete the Pivot Table & the resulting data (the summary created using the Pivot Table).
The method you choose will depend on how you want to delete the Pivot Table.īelow are some scenarios that I will be covering in this tutorial: When it comes to deleting a Pivot Table, there are a few different ways you can do this. Since you’re reading a tutorial about removing or deleting a Pivot Table, I am assuming you already have a Pivot Table(s) in place that you want to remove. Delete the Resulting Data but Keep the Pivot Table.Delete the Pivot Table but Keep the Resulting Data.Delete the Pivot Table and the Resulting Data.
0 kommentar(er)
