Step-by-Step Guide: Removing a PivotTable From Your Microsoft Excel Spreadsheet

Quick Links

• Use a Keyboard Key to Delete a PivotTable
• Remove a PivotTable Using a Ribbon Option

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.

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

Also read: