Delete a pivot table by right-clicking it and selecting Delete, or by clicking anywhere in the table and using the Analyze tab

A pivot table in Excel is a separate object that sits on top of your data — it is not part of the original spreadsheet. This means you can remove it without touching the data underneath. The fastest way is to right-click anywhere inside the pivot table, select Delete, and confirm. If that does not work, click inside the table, go to the Analyze tab at the top, find the Delete button in the Tools group, and select Delete Pivot Table.

The reason this matters is that many people worry deleting a pivot table will erase their original data. It will not. Your source data stays exactly as it was. You are only removing the summary table Excel built from that data.

Key Takeaways

  • Right-click inside the pivot table and select Delete to remove it in one step.
  • If right-click does not show a Delete option, click the Analyze tab at the top and use the Delete button in the Tools group.
  • Deleting a pivot table does not delete your original data — the source spreadsheet remains unchanged.
  • If you delete a pivot table by accident, press Ctrl+Z when ready to undo the deletion.
  • You can delete multiple pivot tables one at a time, or select them all at once and delete them together.

The right-click method works on most versions of Excel

Click anywhere inside the pivot table — it does not matter which cell. Right-click and look for Delete in the menu that appears. Click it. A dialog box will ask if you want to delete the entire pivot table. Select Delete Pivot Table and confirm.

This method works in Excel 2016, 2019, 2021, and Excel on the web. On a Mac, right-click or Control+click the same way. If you are using a trackpad without a right-click button, hold Control while clicking.

If the right-click menu does not show Delete, or if you prefer using the ribbon at the top, move to the Analyze tab instead.

Use the Analyze tab if right-click does not work

Click anywhere inside the pivot table to select it. At the top of Excel, look for a tab labeled Analyze (in newer versions) or PivotTable Tools (in older versions). Click it. In the Tools group on the left side of the ribbon, you will see a Delete button with a small arrow next to it. Click the arrow and select Delete Pivot Table.

This method is more reliable on older versions of Excel and on Excel for Mac, where the right-click menu sometimes does not show all options. The Analyze tab is only visible when a pivot table is selected, so if you do not see it, click inside the pivot table first.

Deleting multiple pivot tables at once

If your spreadsheet has more than one pivot table and you want to remove them all, you can delete them one at a time using either method above. However, if you want to delete them faster, you can select multiple pivot tables and delete them together.

Click the first pivot table. Hold Ctrl (or Cmd on Mac) and click each additional pivot table you want to delete. Once all are selected, right-click and choose Delete, or use the Analyze tab method. Excel will remove all selected pivot tables at once.

Be careful when selecting multiple objects — make sure you are clicking inside the pivot tables themselves, not in empty cells between them.

What happens to your data after you delete a pivot table

Your original data is completely safe. The pivot table is a separate summary that Excel creates from your source data. When you delete the pivot table, you are only removing that summary. The rows and columns you started with remain in your spreadsheet, unchanged and in their original location.

If you had multiple pivot tables built from the same data, deleting one does not affect the others. Each pivot table is independent.

Undo a deleted pivot table if you change your mind

If you delete a pivot table and when ready realize you made a mistake, press Ctrl+Z (or Cmd+Z on Mac) right away. Excel will restore the pivot table exactly as it was, including all the fields, filters, and formatting you had set up.

This undo works only if you have not made other changes since the deletion. If you have performed other actions in the spreadsheet, the undo may not work, and you will need to rebuild the pivot table from scratch. For this reason, it is a good idea to undo when ready if you delete by accident.

Frequently Asked Questions

Will deleting a pivot table delete my original data?

No. A pivot table is a summary that Excel creates from your data — it is not the data itself. When you delete the pivot table, your original spreadsheet stays exactly as it was. You can safely delete any pivot table without worrying about losing the source information.

What if I delete a pivot table by accident?

Press Ctrl+Z (or Cmd+Z on Mac) when ready to undo. This restores the pivot table with all its settings. If you have made other changes since the deletion, undo may not work, and you will need to rebuild the pivot table.

Can I delete just part of a pivot table instead of the whole thing?

No. Excel treats a pivot table as a single object — you either delete all of it or none of it. If you want to remove only certain rows or columns from the summary, you can hide them or rearrange the fields instead of deleting the entire table.

Do I need to delete the pivot table before I delete the source data?

No, but it is a good idea. If you delete your source data first, the pivot table will show an error because it has nothing to summarize. Deleting the pivot table first keeps your spreadsheet clean and prevents confusion.