If you’re like most people, you probably use Microsoft Excel to track data. But if you want to delete a pivot table, there’s a few steps you need to take.
- Open Microsoft Excel and click on the PivotTable button in the top left corner of the screen.
- On the left side of the PivotTable, select the table or data that you want to delete.
- Click on the Delete button in the bottom right corner of the PivotTable window.
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.
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
