Use Slicers to filter data (2024)

Convert data into a table

1. There are four ways to convert data into a table:

   Note:In order to use a slicer, you must convert your data into a table first.

   • Press Ctrl + T.

   • Press Ctrl + l.

   • Select Home > Format as Table.

   • Select Insert > Table.

2. Select OK.

Use a slicer to filter data

1. Select Insert > Slicer.
   

2. Select the fields you'd like to filter.

3. Select OK and adjust your slicer preferences, such as Columns, under Options.

   Note:To select more than one item, hold Ctrl, and then select the items that you want to show. Select and hold the corner of a slicer to adjust and resize it.

4. Select Clear Filter to clear the slicer filter.

Want more?

Filter data in a PivotTable

What's new in Excel for Windows