Under the Table Design tab, click on the Insert Slicer option.

Once the data is converted into Excel table format, the Table Design tab appears in the Excel ribbon. We can see that the data is converted into Excel table format. Enter the data in Where is the data for your table? Box. Step 2: Press the Excel table shortcut keys, Ctrl + T. Step 1: Select any of the cells in the data range. We need to format and convert the above data into an Excel Table using the following steps: So, let us learn how to use slicers in excel with the following example. Now, we know that slicers in excel are used to filter data. If we filter one value in the pivot table, it will also filter the same value in the slicer. Slicer and pivot tables are interdependent.We cannot hide any items from the slicers.However, by changing the report connections, we can link one slicer to impact multiple pivot tables. If the slicer is inserted for one pivot table by default, it will filter only that particular pivot table summary.It can filter the other slicer, so the drill-down is dynamic.Slicers allow users to filter the data with a visual selection.Likewise, we can filter data using slicers in excel. The pivot table shows the summary for the selected region and city. We have filtered the East region from the Region slicer and the ‘New York’ as the City slicer. We can see two slicers for columns Region and City, which help us filter the data for the selected region and city. But, first, let us understand how slicers in Excel work.

Once the slicer is selected, we can customize it to change the color, size, and number of columns to show in the slicer, along with many other custom formatting options.įor instance, consider the following pivot table showing the pricelist of eatables. However, users must click on the value when filtering from the pivot table or chart. Unlike auto filters, slicers will display the values in their list. Slicers in Excel help us to filter the data from a visual filter for pivot tables, pivot charts, and Excel Table formats.

However, Excel introduced a visual filter called Slicer in the 2010 version. Filtering the data in Excel using an auto filter is one of Excel’s most commonly used tools.

Excel slicer templates