- Using a slicer, filter data in a PivotTable.
- Go to Pivot Table Analyze > Filter > Insert Slicer Slicer after selecting any cell in the PivotTable.
- Choose the fields for which slicers should be created. Then press OK.
- For each option you make, Excel will place one slicer on the worksheet; however, you must arrange and size them as you see fit.
- Select the things you want to show in the PivotTable using the slicer buttons.
- Manually filter the data
- Select the arrow next to the column heading. The column you want to filter is indicated by a drop-down arrow.
- Uncheck (Select All) the boxes you want to see, then check the ones you want to see. Then press OK.
Read More: What is the benefit of using formulas in excel sheets?
