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 Slicer, Excel

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.

Insert Slicers Dialog Box, Excel

Click OK; three slicers appear on the screen.

3 Slicers Inserted, Excel Table, Excel

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.

Remove slicer, Slicers, Excel Table

In the Agent Slicer, all the agents are selected now. If I click on Adams, then only Adams agent will be selected.

2 Slicers, Excel Table

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.

Select more than one item in slicer, Excel Table

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.

2 Slicers, Filtered Excel Table

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.

Change the design of slicers, Excel

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!

Quick summary

-> 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.

Download Working File

Using_Slicer_to_Filter_a_Table

Kawser on EmailKawser on FacebookKawser on LinkedinKawser on TwitterKawser on Youtube
Hello!

Welcome to my Excel blog! I am conducting deep dives into the world of Excel. Please join with me and explore Excel deeply.

Keep in mind this African proverb:

"If you want to go fast, go alone,
If you want to go far, go together."

Let's together explore Excel deeply!

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

Solve the Math * Time limit is exhausted. Please reload CAPTCHA.