How to Delete Pivot Table?

Delete Pivot Table in Excel

As you know, a pivot table is used to summarize the raw data into an informative table. And you can easily remove a pivot table by following the below simple steps; generally, the Pivot table has shown the error message-“we can’t make this change for the selected cells because it will affect a pivot table” to protect the accidental deletion of data.

How to Delete Pivot Table From Excel?

Let us understand this with some practical examples.

Example #1 – Removing a Pivot table

Below are the steps used for deleting pivot table from excel –

  1. If you get a we can’t make this change for the selected cells because it will affect a pivot table as shown in the below screenshot, then select the entire Pivot Table by pressing Ctrl + A, and then hit Delete again.

    Delete Pivot Table Example 1

  2. Pick a cell anywhere in the Pivot Table to show the Pivot Tools on the ribbon.

    Click on the Select tab and select the Entire Pivot Table, then hit delete.

    Example 1-1

    or select the clear all option under home the same tab Clear. (As shown in the below screenshot).

    Delete Pivot Table Example 1-2

    Raw Date:

    Example 1-3

    Pivot Table Data:

    Delete Pivot Table Example 1-4

Example #2 – Remove the Pivot Table by Keeping the Stored Data

In this example, we first create a backup for the pivot table data then remove the pivot tablePivot TableA Pivot Table is an Excel tool that allows you to extract data in a preferred format (dashboard/reports) from large data sets contained within a worksheet. It can summarize, sort, group, and reorganize data, as well as execute other complex calculations on it. read more.

  • Copy the data from the pivot table and paste it as values to another location, as shown in the below figure.
Example 1-5
  • Then follow the step of Removing a Pivot Table.

Example #3 – Removing the Entire Worksheet

You can delete the entire excel sheet that has the pivot table to remove a pivot table from an Excel workbook.

Select the sheet in which your pivot table is located, then right-click on the sheet name, then select delete sheet to delete the entire worksheet as shown in the below figure.

Delete Pivot Table Example 1-6

Things to Remember Here

  • Always make sure to take a backup of data before removing the pivot table.

You can download this How to Remove Pivot Table in Excel template here –  Remove Pivot Table Excel Template

Recommended Articles

This has been a step by step guide on how to delete the Pivot Table in Excel. Here we discuss how to Remove Pivot Table by keeping the stored data safe along with practical examples and downloadable templates. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion