Microsoft Office Tutorials and References
In Depth Information
Filtering Excel table data by using slicers
Select the Month and Region check boxes, and then click OK to add slicers for the
Month and Region columns.
In the Month slicer, click the January item and then, holding down the Shift key, click
the April item. Excel updates your table to display values for the months of January,
February, March, and April.
In the Region slicer, click the North Central item and then, holding down the Ctrl
key, click the Northwest item. Excel updates your table to display values for the
North Central and Northwest regions.
Right-click the Region slicer and then click Remove “Region” to delete it. Excel
deletes the slicer and removes its filter from the table.
In the Month slicer, click the June item to display results for the month of June.
In the Month slicer, click the Clear Filter button to remove the filter and display the
Right-click the Month slicer and then click Remove “Month” to delete it.
CLEAN UP Close the Slicers workbook, saving your changes if you want to.