How can a user remove or delete a PivotTable?

Select the PivotTable and click Clear All in the Actions group under the Options tab on the PivotTable Tools contextual tab.

Delete the worksheet that contains the PivotTable.

Select the columns and/or rows containing the PivotTable, and press Delete on the keyboard.

All of the options described are correct.

Question

Lillie Odom

Computers & Technology

14 November, 22:50

How can a user remove or delete a PivotTable?

Select the PivotTable and click Clear All in the Actions group under the Options tab on the PivotTable Tools contextual tab.

Delete the worksheet that contains the PivotTable.

Select the columns and/or rows containing the PivotTable, and press Delete on the keyboard.

All of the options described are correct.

+2

Answers (1)

Know the Answer?

Tiana Kidd · Answer 1

All the options are correct.

Explanation:

We can select the Pivot Table and then click Clear All in the actions group which is under the Options tab on the contextual tab of the Pivot Table.

You can delete the worksheet as well that contains the Pivot Table.

Or you can select the columns and/or rows which contains the Pivot Table, and finally press the Delete on the keyboard.

Hence, all the options are correct.