• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • 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
    • 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
        • Set Out of Office Message in Microsoft Teams
          How to Set Out of Office Message in Microsoft Teams

Primary Sidebar



Gadget Guide

  • Should You Buy MacBook or Windows Laptop
  • How Much RAM Is Required in a Computer?
  • 12 Reasons to Switch to Chromebook
  • Check RAM Size & Type In Windows 10/11
  • Which Chromecast Model to Buy




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