How to Remove a Pivot Table in Excel (3 Ways)

Charts & pivot tables · Updated November 22, 2026

Removing a pivot table in Excel is not the same as deleting its data. The pivot table is a separate object sitting on top of your source data, so you can remove it entirely without touching the original numbers. This guide shows you three quick ways to delete a pivot table, including how to keep the calculated values if you need them.

What You’ll Need

  • An Excel workbook containing at least one pivot table.
  • The worksheet where the pivot table is located (the pivot table itself, not the source data).
  • If you want to keep the results, a blank area on the same sheet or a new worksheet to paste the values.

Step-by-Step

Method 1: Delete the Entire Pivot Table

  1. Click anywhere inside the pivot table. This makes the PivotTable Analyze tab appear on the ribbon (it may be called Analyze on a Mac).
  2. Go to PivotTable Analyze > Select > Entire PivotTable. This selects the whole pivot table, not just the active cell.
  3. Press the Delete key on your keyboard. The pivot table is removed, and the source data remains untouched.

Method 2: Delete the Pivot Table via the Right-Click Menu

  1. Right-click any cell inside the pivot table.
  2. Choose PivotTable Options from the context menu (on some versions, it’s under More Options).
  3. In the dialog box, click the Alt Text tab (or Layout & Format on older versions).
  4. Click the Delete button at the bottom of the dialog. Confirm if prompted.

Method 3: Copy and Paste as Values (Keep the Numbers)

  1. Click anywhere inside the pivot table, then press Ctrl + A (Windows) or Cmd + A (Mac) to select all cells in the pivot table range.
  2. Press Ctrl + C (Windows) or Cmd + C (Mac) to copy the selected cells.
  3. Click a blank cell outside the pivot table (for example, a few columns to the right or a new worksheet).
  4. Right-click the blank cell, then under Paste Options, choose Values (the clipboard icon with “123”). This pastes only the numbers and text, not the pivot table structure.
  5. Now delete the original pivot table using Method 1 or 2. The pasted values remain.

Common Mistakes

  • Deleting the source data instead of the pivot table. If you select cells in the underlying data and press Delete, you erase your raw numbers. Always select the pivot table itself.
  • Using the Clear button instead of Delete. PivotTable Analyze > Clear > Clear All only removes the fields and layout, leaving an empty pivot table frame. It does not remove the pivot table object.
  • Pressing Backspace instead of Delete. Backspace deletes the contents of the active cell only, which can corrupt the pivot table layout. Use the Delete key after selecting the entire pivot table.
  • Forgetting to select the whole pivot table. If you only select a few cells and press Delete, Excel may show an error or delete only those cells, leaving a broken pivot table.

Tips

  • Use a keyboard shortcut to select the whole pivot table: Click inside the pivot table, then press Ctrl + A (Windows) or Cmd + A (Mac) twice if needed – the first press selects the active field, the second selects the entire pivot table.
  • If you plan to reuse the pivot table later, instead of deleting it, copy the worksheet and keep the copy as a backup. Then delete the pivot table on the original sheet.
  • To remove multiple pivot tables at once, hold Ctrl and click each pivot table (if they are on the same sheet) or use the PivotTable Fields pane to switch between them. There is no bulk delete, but you can delete them one by one quickly.
  • After deleting, check for hidden sheets. Some pivot tables are placed on separate sheets. If you don’t see the pivot table on the main sheet, click through all sheet tabs at the bottom.

Troubleshooting

  • The PivotTable Analyze tab is not visible. Click any cell inside the pivot table. The tab appears only when the pivot table is active. If you clicked outside, the tab disappears.
  • Delete key does nothing. Make sure you selected the entire pivot table using PivotTable Analyze > Select > Entire PivotTable. If you only selected a cell, the Delete key may not work.
  • Error: “Cannot change part of a pivot table.” This happens when you try to delete individual cells or rows. You must select the entire pivot table first, then delete.
  • Pivot table is on a protected sheet. If the worksheet is protected, you need to unprotect it first: go to Review > Unprotect Sheet (enter the password if prompted), then delete the pivot table.
  • Pasted values are not what you expected. If you copied only the visible cells, you might have missed hidden rows or columns. Before copying, ensure all rows/columns are visible (right-click the row/column header and choose Unhide).

Frequently Asked Questions

Does deleting a pivot table delete the source data?

No. The pivot table is a separate object. Deleting it only removes the pivot table; your original data remains intact.

Can I undo deleting a pivot table?

Yes, immediately after deleting, press Ctrl + Z (Windows) or Cmd + Z (Mac) to undo. This works as long as you haven’t performed other actions in between.

How do I remove a pivot table but keep the totals?

Copy the pivot table and paste as values (Method 3). This keeps the numbers, including totals, as static text.

Why is the PivotTable Analyze tab missing?

That tab only appears when you click inside a pivot table. If you click outside, the tab disappears. Click any cell within the pivot table to bring it back.

Can I delete a pivot table from the PivotTable Fields pane?

No, the PivotTable Fields pane only manages fields. To delete the pivot table, you must use the methods above (select and delete).

What happens to slicers or timelines connected to the pivot table?

When you delete the pivot table, any connected slicers or timelines become disconnected and may show errors. You should delete them separately by selecting them and pressing Delete.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.