|11: SoRTING AND FILTERING WoRkShEET DATA|
Define a filter 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.
Clearing and removing slicers
TIP You can also clear a slicer’s filter by clicking the slicer and
then pressing Alt+C.