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.

Select the entire pivot table.

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.

Select the tab

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

Choose Select  data-recalc-dims= Entire PivotTable.” width=”554″ height=”359″ onerror=”this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);”/>

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

And your selected pivot table is gone from your spreadsheet. Are you ready.


Want to quickly remove all images from your Excel spreadsheet? If so, you are just a few clicks away!

RELATED: How to quickly remove all images from a Microsoft Excel spreadsheet