How to Delete a Pivot Table in Excel?

Click anywhere inside the pivot table

Go to the PivotTable Analyze or Options tab

Select the entire pivot table

Press Delete or Backspace

To remove only the pivot table but keep the worksheet, delete the pivot table range

To remove the pivot table and its data source connection, delete the pivot table and clear any related cache if needed

To remove the pivot table completely, delete the worksheet containing it if that is desired

Suggested for You

Trending Today