Microsoft Office Tutorials and References
In Depth Information
14. In the Search box, type Ju .
Excel displays the months June and July in the filter list.
15. Click OK .
Excel applies the filter.
16. On the Options contextual tab of the ribbon, in the Actions group, click the Clear
button, and then click Clear Filters .
Excel clears all filters from the PivotTable.
17. On the Options contextual tab of the ribbon, in the Sort & Filter group, click
Insert Slicer .
The Insert Slicers dialog box opens.
18. In the Insert Slicers dialog box, select the Center check box, and then click OK .
A Slicer for the Center field appears.
19. Click the Atlantic item.
Excel filters the PivotTable so only results for the Atlantic center appear.