How to delete a pivot table in Microsoft Excel

If you no longer use a specific pivot table in your spreadsheet, you have two ways to delete the table in Excel. There is a keyboard method as well as a ribbon menu option to remove pivot tables. Here’s how to use them.

RELATED: How to use pivot tables to analyze Excel data

Use a keyboard key to delete a pivot table

A quick way to remove a pivot table from your spreadsheet is to use the Delete key on your keyboard.

To get started, start your spreadsheet with Microsoft Excel. Then, in your spreadsheet, select the pivot table you want to delete.

While your table is selected, on your keyboard, press the Delete key.

Warning: Excel doesn’t display any warning when you use the Delete key to delete a table, so make sure you’re okay with losing your table data.

If you ever accidentally delete a table, you can restore it by quickly pressing Ctrl + Z (Windows) or Command + Z (Mac).

Thus, it is also quick and easy to delete blank rows and columns in Excel.

RELATED: How to quickly and easily delete blank rows and columns in Excel

Delete a pivot table using a ribbon option

Another way to clear a pivot table in your spreadsheet is to use an option on Excel’s ribbon.

To use this method, first, click on any cell in your pivot table.

On the Excel ribbon at the top, click the “PivotTable Analysis” tab.

On the “PivotTable Analysis” tab, in the “Actions” section, click Select > Entire PivotTable. This highlights the table in your spreadsheet.

ssazglobe