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. 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.
The data connection, placement of the pivot table and the pivot table cache remain intact. Right-click and select Refresh to refresh the pivot table.īelow is the Clear All command in the Ribbon in Excel:.Add or remove fields in the Pivot Table Fields task pane.You also have the option of resetting a pivot table by deleting pivot table filters, labels, values and formatting but retaining the pivot table. Deleting pivot table filters, labels, values and formatting You can then delete the original pivot table if you want. 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 also copy and paste pivot table values in another worksheet or workbook as well. 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. The pivot table should be deleted and replaced with values.īelow is the Paste drop-down menu in Excel: Right-click any cell in the selected pivot table.To 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. You can delete a pivot table and convert it to values. Deleting a pivot table and converting it to values 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.
However, if you have applied filters in the pivot table, Ctrl + A will not select the entire pivot table. You can select an entire pivot table by selecting a cell in the pivot table and then pressing Ctrl + A. A drop-down menu appears.īelow is the Select All command in the Ribbon: