• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • iOS
  • Mac
  • Android
  • Office
  • Windows
  • iOS
  • Mac
  • Android
  • Office

How to Delete Pivot Table in Excel

By: Waseem Patwegar

After Creating Pivot Table and using it to create reports, you may want to delete it. You will find below the steps to delete Pivot Table in Excel in three different scenarios.

Delete Pivot Table in Excel

Delete Pivot Table in Excel

The quickest way to Delete Pivot Table in Excel is to delete the worksheet containing the Pivot Table.

Right-click on the worksheet having Pivot Table and click on the Delete option in the right-click menu that appears.

Manually Delete Worksheet in Excel

Another way to delete Pivot Table in Excel is to select any Cell in the Pivot Table and use Control + A Keyboard Shortcut.

However, both these options select only the visible cells in Pivot Table and cannot be used if filters are applied in the Pivot Table.

Also, above methods cannot be used if you want to delete the Pivot Table while retaining the resulting summary created by the Pivot Table.

Hence, we are providing below the steps to Delete Pivot Table along with its data, Delete Pivot Table  while keeping its data and also the steps to Delete Pivot Table data while retaining the Pivot Table.

1. Delete Pivot Table Along With its Data

Follow the steps below to Delete Pivot Table along with all its data.

1. Select any Cell in the Pivot Table.

2. Click on the PivotTable Analyze tab in the top menu bar > click on Actions > Select > Entire PivotTable.

Select Entire Pivot Table Option in Excel

Note: PivotTable Analyze tab appears only when you select any cell within the Pivot Table.

3. Once the Entire Pivot Table is selected, hit the Delete key on the keyboard of your computer to delete the Pivot Table along with its resulting data.

2. Copy Pivot Table Data and Delete Pivot Table

This is a common situation that arises when you want to send only the summary or the resulting data generated by a Pivot Table and not include the Pivot Table in your submission.

1. Select any Cell in the Pivot Table.

2. Click on the PivotTable Analyze tab in the top menu bar > click on Actions > Select > Entire PivotTable.

Select Entire Pivot Table Option in Excel

3. With entire Pivot Table selected, right-click on any Cell of the Pivot Table and click on Copy.

Copy Pivot Table Data

4. Next, right-click on an empty Cell in the worksheet and click on the Paste Special option.

Paste Pivot Table Data

Note: You can also paste Pivot Table data on a New Worksheet.

5. On Paste Special Dialogue box, select the Values option and click on OK.

Paste Special Dialogue Box in Excel

6. As you can see below, only the Summary or the resulting data created by Pivot Table has been pasted.

Copy Pivot Table Data in Same Worksheet

After pasting Pivot Table data, you can delete the Pivot Table by repeating the steps to select the Entire Pivot Table and pressing the Delete button.

3. Delete Pivot Table Data but Keep Pivot Table

In this case, you are trying remove the Summary or resulting data created by the Pivot Table, while still retaining the Pivot Table for reuse.

1. Select any Cell in the Pivot Table.

2. Click on the PivotTable Analyze tab in top menu bar > click on Actions > Clear > Clear All.

Clear All Pivot Table Data

3. This will totally clear the resulting data created by Pivot Table and you will end up with a blank Pivot Table.

Blank Pivot Table in Excel

You can reuse the Blank Pivot Table to build another report and analyze data in some other way.

Related
  • How to Create Pivot Table From Multiple Worksheets
  • How to Add or Remove Subtotals in Pivot Table
  • How to Change Pivot Table Data Source and Range

You May Also Like
    • Microsoft Excel Has Blocked Macros from Running
      Fix: Microsoft Excel Has Blocked Macros from Running Error
      • Prevent Outlook From Adding Calendar Events
        How to Prevent Outlook From Adding Calendar Events
        • Show Developer Tab in Excel Ribbon Menu
          Add or Show Developer Tab in Excel Ribbon Menu

Primary Sidebar

Twitter
Facebook



Recent Posts

  • How to Set Static IP Address in Windows 11
  • Compass Not Working on iPhone: How to Fix?
  • How to Remove Login Password in Windows 11
  • Fix: Do Not Disturb Keeps Turning Automatically on iPhone
  • Downloads Folder Missing from Finder Sidebar on Mac



About | Privacy Policy | Disclosure | Terms | Contact
© 2023 Techbout.com · All Rights Reserved