Delete a PivotTable
- Pick a cell anywhere in the PivotTable to show the PivotTable Tools on the ribbon.
- Click Analyze > Select, and then pick Entire PivotTable.
- Press Delete.
How do I remove PivotTable but keep data?
How to Remove Pivot Table But Keep Data in Excel?
- Step 1: Select the 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.
How do I change a PivotTable to a regular table?
Convert a Pivot Table to table
- First, you have to create a pivot table from your table (Insert >> Tables >> PivotTable).
- After you add a pivot table, you have to choose fields. ...
- Check if the PivotTable is updated. ...
- Create a new sheet and paste the data there. ...
- Or, you can right-click a cell and choose paste by values.
