The fastest way to remove a pivot table

To delete a pivot table in Excel, right-click anywhere inside the table and select Delete from the menu, then choose whether to delete just the pivot table or the pivot table and its source data. The entire pivot table — all rows, columns, and calculations — disappears, but your original data stays intact unless you specifically choose to remove it too.

If the right-click menu does not appear or looks different, make sure your cursor is actually inside the pivot table area. Clicking on the table border or outside it will show you different options. The PivotTable Analyze tab (or PivotTable Tools in older Excel versions) also appears automatically when you click inside the table, and you can use that ribbon to delete the table as well.

Key Takeaways

  • Right-clicking inside the pivot table and selecting Delete removes the entire table in one step.
  • Your original data is not deleted unless you explicitly choose that option in the confirmation dialog.
  • The PivotTable Analyze tab in the ribbon offers a Delete button as an alternative to right-clicking.
  • If you delete a pivot table by mistake, Ctrl+Z (or Cmd+Z on Mac) will undo the deletion when ready.

Using the ribbon menu instead of right-clicking

If you prefer using the menu bar, click anywhere inside your pivot table to set up it. The PivotTable Analyze tab will appear in the ribbon at the top of Excel. On the far left of that tab, you will see a Delete button (sometimes labeled Delete Table). Click it, and Excel will ask you to confirm whether you want to delete only the pivot table or the pivot table and its underlying data.

This method works the same way as right-clicking and produces the same result. Some people find it easier because the button is always in the same place, whereas the right-click menu can vary depending on which cell you click. Both approaches delete the entire pivot table at once.

What happens to your data when you delete

When you delete a pivot table, Excel gives you two choices. The first option deletes only the pivot table itself — the summary, the calculations, the grouped rows and columns — but leaves your original data untouched in its original location. If your source data was in columns A through D on Sheet1, it stays there exactly as it was before you created the pivot table.

The second option deletes both the pivot table and the source data. Choose this only if you are certain you no longer need the original data and you created the pivot table from data that was not important to keep. Most of the time, you want the first option: delete the pivot table but keep the data.

Clearing a pivot table without deleting it

If you want to remove the contents of a pivot table but keep its structure and formatting in place, you can clear it instead of deleting it. Click inside the pivot table, go to the PivotTable Analyze tab, and look for a Clear button (or Clear All). This removes all the data and calculations from the table but leaves the empty framework behind.

This approach is useful if you plan to rebuild the same pivot table with different data or if you want to keep the layout but refresh it with new information. For most situations, though, a full delete is simpler and cleaner than clearing.

Removing a pivot table from a shared workbook

If you are working in a shared Excel file (one that multiple people can edit at the same time), you may not be able to delete a pivot table while sharing is turned on. Excel will show you a message saying the action is not allowed in a shared workbook. To delete the pivot table, you need to turn off sharing first.

Go to the Review tab in the ribbon and click Share Workbook (or Unshare Workbook depending on your Excel version). Uncheck the box that says the workbook is shared, save the file, and then you can delete the pivot table normally. Once you are done, you can turn sharing back on if needed.

Undoing a deletion if you change your mind

If you delete a pivot table and when ready realize you made a mistake, press Ctrl+Z on Windows or Cmd+Z on Mac to undo the deletion. This works as long as you have not closed the file or performed other actions since the deletion. The pivot table will reappear exactly as it was, with all its formatting and calculations intact.

If you have already closed the file or performed many other actions, undo may not work. This is why it is a good idea to pause for a moment after deleting a pivot table to make sure you did not need it. If you think you might want to use the same pivot table again in the future, consider making a copy of the sheet first before deleting anything.

Frequently Asked Questions

Will deleting a pivot table delete my original data?

No, unless you specifically choose that option. When you delete a pivot table, Excel asks whether you want to delete just the table or the table and its data. Choose the first option to keep your original data. Your source data will remain in its original location on the spreadsheet.

Can I delete just one row or column from a pivot table instead of the whole thing?

No, you cannot delete individual rows or columns from a pivot table the way you would from a regular spreadsheet. You can hide rows or columns by clicking them and selecting Hide, but to permanently remove them you have to rebuild the pivot table without that field. If you need to delete specific data, it is usually easier to work with your original data instead.

What if the Delete button is grayed out?

The Delete button is usually grayed out if the workbook is shared or if you are not actually inside the pivot table. Click directly on a cell within the pivot table to set up it, and the button should become available. If the workbook is shared, you will need to turn off sharing first.

Can I recover a pivot table after I delete it?

Yes, if you use Ctrl+Z when ready after deleting it. If you have already closed the file or saved it, recovery is not possible through Excel's undo feature. This is why it is worth double-checking before you delete, especially if the pivot table took time to set up.