How To Delete A PivotTable In Microsoft Excel - How-To Geek

If you don't use a specific PivotTable in your spreadsheet anymore, you have two ways to remove the table in Excel. There's a keyboard method as well as a ribbon menu option to delete PivotTables. Here's how to use them.

Related: How to Use Pivot Tables to Analyze Excel Data

Use a Keyboard Key to Delete a PivotTable

A quick way to remove a PivotTable from your spreadsheet is to use your keyboard's Delete key.

To start, launch your spreadsheet with Microsoft Excel. Then, in your spreadsheet, select the PivotTable you want to delete.

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

Excel shows no warning when you use the Delete key to remove a table, so make sure you're okay with losing your table's data.

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

Like this, it's also quick and easy to remove blank rows and columns in Excel.

Related: How to Quickly and Easily Delete Blank Rows and Columns in Excel

Remove a PivotTable Using a Ribbon Option

Another way to clear a PivotTable in your spreadsheet is to use an option in Excel's ribbon.

To use this method, first, click any cell in your PivotTable.

In Excel's ribbon at the top, click the "PivotTable Analyze" tab.

On the "PivotTable Analyze" tab, in the "Actions" section, click Select > Entire PivotTable. This highlights the table in your spreadsheet.

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

How-To Geek Report: Subscribe and never miss what matters

Unlock your tech-savvy potential and master the digital world with How-To Geek. Subscribe By subscribing, you agree to receive newsletter and marketing emails, and accept Valnet’s Terms of Use and Privacy Policy. You can unsubscribe anytime.

And your selected PivotTable is gone from your spreadsheet. You're done.

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

Related: How to Quickly Remove All Pictures From a Microsoft Excel Spreadsheet