How To Use Excel Slicer

Go crazy clicking slicing and dicing your data.

How to use excel slicer. Click any cell inside the pivot table. A slicer will be created for every field that you selected. Click the insert tab and then click slicer in the filters group in 2013 and 2016 only you can t do. To insert a slicer in an excel table use the following steps. 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.

Select the entire data and press ctrl t to add a table to the data range. You can then select which fields to add and press ok. 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. Hold down the ctrl key to select multiple items in your slicer. Click anywhere in the table or pivottable.

Click the multi select button please see the screenshot below and then click on the items one by one. Different ways to filter an excel slicer. On the analyze tab in the filter group click insert slicer. In the insert slicers dialog box select the check boxes for the fields you want to display then select ok. Excel will then create the slicer object to control the pivot table.

By default all slices of data will be selected. Check country and click ok. 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. Click anywhere inside the slicer box and press alt s to toggle on the multi select button. Click the slicer buttons while holding the ctrl key.

Right click on pivot table field you want and choose add as slicer. To insert a slicer execute the following steps. How to insert a pivot table slicer. Now that you ve converted the data into a table you can generate the slicer almost as easily. Your slicer is now ready.