How To Use Excel Slicer

By default all slices of data will be selected.

How to use excel slicer. In the insert slicers dialog box select the check boxes for the fields you want to display then select ok. Click anywhere in the table or pivottable. Now that you ve converted the data into a table you can generate the slicer almost as easily. After that select any of the cells from the table and then go to insert tab slicer click on the slicer button. 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.

Click any cell inside the pivot table. Click anywhere inside the slicer box and press alt s to toggle on the multi select button. Go crazy clicking slicing and dicing your data. As soon as the table has been created you will see a new tab in the ribbon called design. On the analyze tab in the filter group click insert slicer.

Click the slicer buttons while holding the ctrl key. 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. 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. A slicer will be created for every field that you selected.

Click on ok it will create a table for you. Click the multi select button please see the screenshot below and then click on the items one by one. Check country and click ok. Hold down the ctrl key to select multiple items in your slicer. Different ways to filter an excel slicer.

How to insert a pivot table slicer. 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. 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. Bananas are our main export product to the united states. Excel will then create the slicer object to control the pivot table.