How to Delete a PivotTable in Microsoft Excel


Microsoft Excel logo.

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.

Select the entire PivotTable.

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

Warning: 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.

Select the "PivotTable Analyze" tab at the top.

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

Choose Select > Entire PivotTable.

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





Source link

Leave a Reply

Your email address will not be published.