Using Slicers to Filter Data

Contact Us or call 1-877-932-8228
Using Slicers to Filter Data

Using Slicers to Filter Data

Slicers was a new feature added to Excel 2010, which allows users to filter PivotTable data. In Excel 2013, you can now use slicers to filter table data.

To filter data using slicers:

  1. Click in the table.
  2. From the TABLE TOOLS DESIGN tab, from the Tools group, select Insert Slicer. Insert Slicer Command
  3. In the Insert Slicers dialog box, check the check boxes of the desired slicers. Insert Slicers Dialog Box
  4. Click OK. OK
  5. The slicers are now displayed in the worksheet. Slicers Displayed
Next