How To Use Excel Slicer

Different ways to filter an excel slicer.

How to use excel slicer. Then you right click on the field s you have chosen and click on add as slicer. By default all slices of data will be selected. There are 3 ways to select multiple items in an excel slicer. On the analyze tab in the filter group click insert slicer. Click the insert tab and then click slicer in the filters group in 2013 and 2016 only you can t do.

Bananas are our main export product to the united states. Hold down the ctrl key to select multiple items in your slicer. Check country and click ok. Under this tab you can see the slicers option only from excel 2013 onwards. Go crazy clicking slicing and dicing your data.

Select the entire data and press ctrl t to add a table to the data range. To insert a slicer in an excel table use the following steps. A slicer will be created for every field that you selected. On the right side of the excel sheet you can select the data field s you want to create a slicer for by checking the box next to the field. Click united states to find out which products we export the most to the united states.

Your slicer is now ready. Obviously slicers were designed to work with pivottables and pivotcharts and if you have excel 2013 onwards then you can also use slicers with excel tables. 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 execute the following steps. Now that you ve converted the data into a table you can generate the slicer almost as easily.

How to insert a pivot table slicer. Click on ok it will create a table for you. On the home tab go to insert slicer. After that select any of the cells from the table and then go to insert tab slicer click on the slicer button. How to add a slicer to a pivottable select the pivot table to which you want to add a slicer go to the pivottable analyze tab insert slicer.