How to Use Slicers to Filter a Table in Excel 2013
In this post today, we will be discussing the Slicer Feature in Excel.
It is also possible to filter a table using Slicer feature. This feature is visually appealing, but not an efficient way to filter data in a table.
Slicers take too much place on your screen. They are only for those who find normal filtering techniques too much complicated.
Slicer Feature was first introduced in Excel 2010. At that time they worked only for pivot table filtering. From Excel 2013, it is now also available for tables.
To add one or more Slicers, select any cell in the table, select Design contextual tab, and click on the “Insert Slicer” command on the Ribbon.
Insert Slicers dialog box appears. You see the column headings are listed in the dialog box with the check boxes next to them.
I select Agent, Area, and List Price column headings.
Click OK; three slicers appear on the screen.
I move them to a new location using dragging and dropping method.
You can make them smaller in size.
You see, in the Agent slicer, all the Agent names are available, in the Area slicer, all the Areas are available, and in the List Price Slicer, all the unique prices are available.
So it is not a good idea to make a Slicer of a numeric column that has a huge number of unique values.
You can delete a Slicer if necessary. I click on the List Price slicer to select it. To delete, I can press Delete on my keyboard, or I can right click on the List Price slicer and choose Remove List Price, List Price Slicer will be removed.
In the Agent Slicer, all the agents are selected now. If I click on Adams, then only Adams agent will be selected.
You can select more than one item from the list just pressing CTRL. I press CTRL and select Bennet, you see both Barnes and Bennet are selected now.
At this moment, agents Barnes and Bennet and all the areas are selected. To filter Area, click on any area. I click on S. County. So right now Barnes and Bennet agents and S. County are selected. Simple way really. The table is showing data for only agents Barnes and Bennet and for Area S. County. You can remove filtering by just clicking the Clear Filter icon at the top right corner of the Slicer. Or you can press Alter and C keys on your keyboard after selecting the slicer.
You see when you select a Slicer; an Options Slicer Tools contextual tab appears in the Tab List. Click on this Options contextual tab. You see so many options are available to work with the Slicer. I change only the Slicer Style. There are so many other options. Work with them by yourself.
So this brings us to the end of our tutorial on using slicers to filter. They are hardly used but its good to know about them.
See you soon with a new exciting post on Excel n many of its features!
-> To Open the Insert Slicer dialog box:
Click on a cell in the Table -> Click on the Design Contextual Tab -> Click on the Insert Slicer command in the Tools Group.
-> To Delete a Slicer from the Screen:
- Select the Slicer -> Press Delete key on your Keyboard.
- Select the Slicer and Right click on the Slicer -> Choose Remove Relevant Slicer command from the list.
-> To Remove Filtering in a Slicer:
- Select the Slicer -> Click on the Clear Filter button at the Top Right corner of the Slicer.
- Select the Slicer -> Press ALT + C on your keyboard.