Microsoft Office Tutorials and References
In Depth Information
Filtering Excel tables by using slicers
Define a filter by using a slicer
1 In the slicer, do any of the following:
a Click an item to display just its related values.
b While pressing the Ctrl key, select multiple items to display those
items’ related values.
c While pressing the Shift key, click two items to display related
values for every value from the first selected item to the second
selected item in the slicer’s list.