Excel Pivot Table Report – Clear All, Remove Filters, Select Mutliple Cells or Items, Move a Pivot Table As applicable to Excel 2007 With the tools available in the Actions group of the ‘Options’ tab (under the ‘Pivot Table Tools’ tab on the ribbon), you can Clear a Pivot Table, Remove Filters, Select Multiple Cells...