Delete / Remove a Pivot Table in Excel & Google Sheets

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on March 12, 2023

This tutorial demonstrates how to delete a pivot table in Excel and Google Sheets.

 

delete pivot initial

 

There are a few different ways to delete a pivot table.

Delete Pivot Table

Select Pivot Table and Delete

  1. In the Ribbon, go to PivotTable Analyze > Actions > Select All.

 

pivottable select all

 

Press the DELETE key. Note that this will only delete the pivot table and not the underlying data that the pivot table relies on.

Delete the Rows or Columns of a Pivot Table

Select all the columns that contain the pivot table, and then press DELETE.

 

delete pivot select columns

 

Or, select all the rows of the pivot table and press DELETE to obtain the same result.

Delete the Pivot Table’s Sheet

Right-click on the sheet tab that contains the pivot table, and then click Delete to remove the entire sheet.

 

delete pivot sheet

 

You can also use VBA to delete a pivot table.

Delete a Pivot Table in Google Sheets

Select all the columns that contain the pivot table, and then press Delete.

 

delete pivot gs

Tip: Try using some shortcuts when you’re working with pivot tables.

AI Formula Generator

Try for Free

See all How-To Articles