Applies ToExcel for Microsoft 365 Excel for the web Excel 2024 Excel 2021 Excel 2019 Excel 2016 Excel 2013

A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. 

When you no longer need a PivotTable, select the entire PivotTable, and press the Delete key to remove it.

If you get a "Cannot change this part of a PivotTable report" message, make sure the entire PivotTable is selected. Press Ctrl+A, and press Delete again.

If you're using a device that doesn't have a keyboard, try removing the PivotTable like this:

  1. Pick a cell anywhere in the PivotTable to show the PivotTable Tools on the ribbon.

  2. Click PivotTable Analyze > Select, and then pick Entire PivotTable. Select Entire PivotTable button in win32.

  3. Pick a cell anywhere on the PivotTable for the "Delete" option to appear. 

Tip: If your PivotTable is on a separate sheet that has no other data you want to keep, deleting that sheet is a fast way to remove the PivotTable.

More about using PivotTables in Excel

1. Right click on a cell anywhere in the PivotTable to show the context menu. 

Delete PivotTable from the context menu on web.

2. Pick Delete PivotTable

You can also select the entire PivotTable (CTRL + A) and press Delete on your keyboard. 

If your PivotTable is on a separate sheet that has no other data you want to keep, right-click the sheet tab and click Delete

Delete a sheet.

More about using PivotTables in Excel for the web

PivotTable on iPad is available to customers running Excel on iPad version 2.82.205.0 and above. To access this feature, please ensure your app is updated to the latest version through the App Store.

To remove a PivotTable from your workbook:

1. Tap and hold a cell anywhere in the PivotTable to show the context menu.

Delete PivotTable option from the context menu on iPad.

2. Tap Delete PivotTable.  

You can also select the entire PivotTable and press the delete key on your keyboard. 

Tips: 

  • To display the keyboard on your iPad, tap a cell outside of the PivotTable range, and then tap the formula bar at the top of the worksheet area: 

  • Show on screen keyboard.

If your PivotTable is on a separate sheet that has no other data you want to keep, tap the sheet tab at the bottom of the screen and select Delete

Delete worksheet on iPad

You can also delete the rows or columns spanning the entire range of your PivotTable if they don’t contain other data you want to keep: 

Delete columns spanning a PivotTable on iPad

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.