slicers

Blog

How to use slicers in Excel – Computerworld

To do this, click 2018 in the year slicer. This will deselect 2017, 2019, and 2020, leaving only 2018 selected. Then in the Category slicer, click Equipment to deselect everything except Equipment. The result? The table now shows only three rows, all of which contain equipment sales from 2018. The table data has been filtered according to our selections, showing…