In 2010 or 2007: click anywhere in the PivotTable, and then click Options > Clear > Clear Filters. In 2016 or 2013: Click anywhere in the PivotTable, and then click Analyze > Clear > Clear Filters. To remove all filtering at once, see the following: Click it to change or clear the filter by clicking Clear Filter From. The filtering arrow changes to this icon to indicate that a filter is applied. To see more items in the list, drag the handle in the bottom-right corner of the filter gallery to enlarge it. In the list of row or column labels, uncheck the (Select All) box at the top of the list, and then check the boxes of the items you want to show in your PivotTable. In the PivotTable, click the arrow on Row Labels or Column Labels. Turn filtering options on or off Filter data manually
Show specific text, values, or dates onlyįilter by selection to display or hide selected items only Use any of the following filtering features instead of or in addition to using slicers to show the exact data you want to analyze. Tip: To change how the slicer looks, click the slicer to show the Slicer Tools on the ribbon, and then apply a slicer style or change settings on the Options tab.
