Insert slicers

1. Select a cell inside a table or PivotTable.

2. On the Insert tab, select   Slicer.

3. Select the checkboxes for the fields you want to display and select OK.

For more info, see Use slicers to filter data.

1. Select a cell inside a table or PivotTable.

2. On the Insert tab, select   Slicer.

3. Select the checkboxes for the fields you want to display and select OK.

For more info, see Use slicers to filter data.

Filtering with a Slicer isn't currently possible in Excel for the web. You can, however, filter with a Slicer in the Excel desktop app.

• To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.

  

Don't have the Excel desktop app? Try or buy Microsoft 365.