Slicers are a more visual way to filter the data in an Excel table
You can download the workbook here to follow along.
Slicers are an option in Excel that allows you to filter the data in a table more visually and easier. Click anywhere in your table, and on the contextual Design tab that appears, select Insert Slicer:
A dialog box will appear with a list of each of the headers in your table. You can now check to select which you want to filter by. Here I’ve chosen Salesman, Model, Region, and New/Used:
These four slicers now appear in my worksheet:
And I can size them and rearrange them any way I’d like:
Now, by clicking on any of the fields within each slicer, I can filter the data for that column and visually see what is filtered in each. By holding down the Ctrl key I can select multiple items within a slicer:
Clicking on the red “X” in the upper right corner will remove that filter from the table:
You can right click on any slicer to remove it, or modify some of the settings:
Slicers can be a very valuable tool in Excel. Try them, play around with the options. Note that if you reduce the height of a slicer to be shorter than the list of options, a scroll bar will automatically appear to allow access to all the items in the list.