How to Remove Pivot Table But Keep Data in Excel?

Configurare noua (How To)

Situatie

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:

Solutie

Pasi de urmat

Select the Pivot table.

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

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

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

Click Ctrl+V, to paste the data.

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

Now, again select the entire Pivot table.

  • Delete it using the Delete key on the keyboard.
  • Or you can also choose the Clear All command from the Hometab => 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.

Tip solutie

Permanent

Voteaza

(3 din 7 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?