Open In App

How to Remove Pivot Table But Keep Data in Excel?

Last Updated : 27 May, 2021
Improve
Improve
Like Article
Like
Save
Share
Report

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.


Like Article
Suggest improvement
Previous
Next
Share your thoughts in the comments

Similar Reads