How to Use Slicers in Excel

Slicers act as visual filters, allowing you to filter data and visualise it either in a table or as a chart. You can easily create Slicers in Excel.

First enter your data into Excel and put it into a table with headers.

excel slicers

Highlight your data in the table, click the design tab and then click insert Slicer.

excel slicers

Select the Slicer that you want to add and click OK.

Excel Slicers

The Slicer can then be used to filter your data.

excel slicers

If you add a chart you can also use the Slicer to filter the data in that.

excel slicers excel slicers