The blue highlighted buttons (East, North, South & West) are all selected. Let’s try to understand it with a very simple example. As soon as you insert a slicer, you click on any button to filter your data. We will discuss three important things now. Now we will learn how to use the Slicers since we know how to insert one. Related: How to Link/Connect a Single Slicer with Multiple Pivot Tables in Excel How to use Slicer in Excel Select the column that you want to use in the slicer.In the end, tickmark the column that you want to use as a filter (you can also tick mark more than one column) and click OK.Once you click on the button you have a dialogue box with all the columns names to select out them to insert a slicer.After that, select any of the cells from the table and then go to → Insert Tab → Slicer (click on the slicer button).First of all, press CTRL+T to convert the data (DOWNLOAD) into an Excel table, or you can also go to the Insert tab and click on the table.To insert a SLICER in an Excel Table use the following steps. You can connect it with a table or a pivot table and customize it the way you want (Color, Font, Buttons, etc.). Unlike a standard filter, it shows you all the available items that you can use to filter as buttons. What is an Excel Slicer?Īn Excel Slicer is a bunch of buttons that you can use to filter data from a column.

That’s why it is a part of our ADVANCED EXCEL SKILLS, and today in this tutorial, we will be exploring it in detail. Slicer makes your data filtering experience a whole lot better. One of the best ways to quickly analyze data in Excel is to use filters, and the best way to filter data is to use SLICER, period.

Excel how many rows after filter