Skip to content
Related Articles

Related Articles

Improve Article

How to Remove Pivot Table But Keep Data in Excel?

  • Last Updated : 27 May, 2021
Geek Week

In this article, we will look into how to remove the Pivot Table but want to keep the data intact in Excel.

To do so follow the below steps: 

Step 1: Select the Pivot table. 

  • To select the table, go to Analyze tab
  • Select the menu and choose the Entire Pivot Table.

Step 2: Now copy the entire Pivot table data by Ctrl+C.



Step 3: Select a cell in the worksheet where you want to paste the data. 

Step 4: Click Ctrl+V, to paste the data. 

Step 5: Click on the Ctrl dropdown. Choose the value(v) option from Paste options. 

Step 6: Now, again select the entire Pivot table. 

Step 7: Delete it using the Delete key on the keyboard.

Step 8: Or you can also choose the Clear All command from the Home tab => Editing section => Clear dropdown. 

You will find your pivot table will be completely deleted from the worksheet. Thus, we can delete the pivot table without losing pivot table data.

Attention reader! Don’t stop learning now. If you are an Excel beginner (or an intermediate) and want to learn Excel, Geeksforgeeks brings the perfect course for you to start, Diving Into Excel

My Personal Notes arrow_drop_up
Recommended Articles
Page :