How to Use Slicers in Excel
Slicers are a feature in Excel that provide an easy way to filter table data. They allow you to filter and re-filter your data quickly so it’s easy to find the exact information you need. Slicers work well when used with both tables and PivotTables.
You can also click the Insert tab, then click Slicer.
The Insert Slicers dialog box appears. All the column headings in the table are listed here.
A separate slicer will be created for each column that’s selected.
The slicers appear in the worksheet. You can now move or resize them as needed.
After a slicer is created, it appears on the worksheet alongside the table. The slicers will be layered on top of one another if there is more than one, but they can easily be repositioned.
The table is filtered to show only the selected value(s).
While holding down the Ctrl key, simply click the value again to stop filtering the selected data.
Before you delete a slicer from a worksheet, make sure you clear it. Deleting a slicer doesn’t clear the filter.
All the filters are cleared, but the Slicer remains on the worksheet.
Click the slicer and press the Delete key.
Free to distribute with our compliments; we hope you will consider our paid training.