Delete a Pivot Table in a Microsoft Excel Workbook

by Avantix Learning Team | Updated June 19, 2020

Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows)

A pivot table can be deleted in an Excel workbook in several ways. You can delete a pivot table, convert a pivot table to values or clear data and customizations from a pivot table to reset it. When a pivot table is created from source data in a workbook, Excel creates a pivot cache in the background. If you delete a pivot table or a source worksheet with the original data, Excel still retains the cache.

Recommended article: 10 Great Excel Pivot Table Shortcuts

Do you want to learn more about PowerPoint? Check out our virtual classroom or live classroom PowerPoint courses >

Deleting a pivot table

To delete a pivot table:

  1. Select a cell in the pivot table.
  2. Click the PivotTable Tools Analyze or Options tab in the Ribbon.
  3. In the Actions group, click Select. A drop-down menu appears.
  4. Click Entire PivotTable.
  5. Press Delete.

Below is the Select All command in the Ribbon:

Select drop-down menu in Excel to select an entire pivot table.

You can select an entire pivot table by selecting a cell in the pivot table and then pressing Ctrl + A. However, if you have applied filters in the pivot table, Ctrl + A will not select the entire pivot table.

You can also delete a pivot table by deleting the worksheet on which it appears (assuming there is no other data on the sheet) or by deleting all of the rows on which the pivot table appears.

Deleting a pivot table and converting it to values

You can delete a pivot table and convert it to values. This can be useful if you want to share the pivot table summary information with clients or colleagues.

To delete a pivot table and convert it to values:

  1. Select a cell in the pivot table.
  2. Click the PivotTable Tools Analyze or Options tab in the Ribbon.
  3. In the Actions group, click Select. A drop-down menu appears.
  4. Click Entire PivotTable.
  5. Right-click any cell in the selected pivot table.
  6. Click Copy. You can also press Ctrl + C.
  7. Click the Home tab in the Ribbon.
  8. In the Clipboard group, click Paste. A drop-down menu appears.
  9. Click Paste Values. The pivot table should be deleted and replaced with values.

Below is the Paste drop-down menu in Excel:

Paste drop-down menu in Microsoft Excel.

If you copy and paste a pivot table using Ctrl + C and then Ctrl + V, Excel will make a copy of the pivot table, not the values.

You can also copy and paste pivot table values in another worksheet or workbook as well. If you press Ctrl + C and then Ctrl + Alt + V, Excel will display the Paste Special dialog box and you can then click Values and click OK. You can then delete the original pivot table if you want.

Deleting pivot table filters, labels, values and formatting

You also have the option of resetting a pivot table by deleting pivot table filters, labels, values and formatting but  retaining the pivot table.

To delete pivot table data:

  1. Select a cell in the pivot table.
  2. Click the PivotTable Tools Analyze or Options tab in the Ribbon.
  3. In the Actions group, click Clear. A drop-down menu appears.
  4. Click Clear All.
  5. Add or remove fields in the Pivot Table Fields task pane.
  6. Right-click and  select Refresh to refresh the pivot table.

Below is the Clear All command in the Ribbon in Excel:

Excel Clear All command for a pivot table to delete data.

The data connection, placement of the pivot table and the pivot table cache remain intact. If there is a pivot chart associated with the pivot table, the Clear All command also removes related pivot chart fields, chart customizations and formatting.

If pivot tables are sharing a data connection or if you are using the same data between two or more pivot tables, then if you select Clear All for one pivot table, you could also remove the grouping, calculated fields or items and custom items in shared pivot tables. A dialog box should appear if Excel is going to remove items in shared pivot tables and you can cancel the operation.

Subscribe to get more articles like this one

Did you find this article helpful? If you would like to receive new articles, join our email list.

More resources

How to Remove Blanks in a Pivot Table in Excel (6 Ways)

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

How to Convert Seconds to Minutes and Seconds in Excel Worksheets

How to Change Commas to Decimal Points in Excel and Vice Versa (5 Ways)

10 Excel Flash Fill Examples (Extract, Combine, Clean and Format Data with Flash Fill)

Related courses

Microsoft Excel: Intermediate / Advanced

Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools

Microsoft Excel: Introduction to Visual Basic for Applications (VBA)

VIEW MORE COURSES >

Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 18 King Street East, Suite 1400, Toronto, Ontario, Canada (some in-person classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at info@avantixlearning.ca if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.

Copyright 2023 Avantix® Learning

You may also like

Excel XLOOKUP Function (Overview, Syntax + Formula Examples)

Excel XLOOKUP Function (Overview, Syntax + Formula Examples)

The XLOOKUP function is a replacement for Excel's traditional VLOOKUP function (as well as HLOOKUP and INDEX / MATCH functions). It has a new set of arguments and is available in Excel 2021 and 365. It allows you to look up a value from an array in a range or table and return one or more results. One of the primary benefits of XLOOKUP is that it can look up from columns to the left in a data set and return a range.

How to Use Go to Special in Excel to Find, Select, Replace and Format Data

How to Use Go to Special in Excel to Find, Select, Replace and Format Data

You can use Go To Special in Excel to quickly find and select cells of a specific type within your worksheet. It only selects cells in the current worksheet, not the entire workbook. Go To Special also searches within the selected range if a range has been selected. You can find many useful things using the Go To Special dialog box including formulas, constants, blanks, visible cells and conditional formatting. After you select multiple cells with Go To Special, you can enter data in the selected cells by pressing Ctrl + Enter or by applying formatting.

How to Lock Cells in Excel (3 Ways)

How to Lock Cells in Excel (3 Ways)

It's easy to lock and protect cells in Microsoft Excel to prevent users from changing data or formulas. This involves a two-step process …

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning |18 King Street East, Suite 1400, Toronto, Ontario, Canada M5C 1C4 | Contact us at info@avantixlearning.ca

Summary
How to Delete a Pivot Table in Excel
Article Name
How to Delete a Pivot Table in Excel
Description
A pivot table can be deleted in an Excel workbook in several ways. You can delete a pivot table, convert a pivot table to values or clear data and customizations from a pivot table to reset it. When a pivot table is created from source data in a workbook,
Author
Publisher Name
Avantix Learning

Pin It on Pinterest

Share This