How To Insert A Slicer In Excel

Excel Slicers

Slicers are a feature in Excel that provide an easy manner to filter tabular array data. They allow you lot to filter and re-filter your data quickly then it's easy to find the exact information you need. Slicers piece of work well when used with both tables and PivotTables.

Insert a Slicer

Click any prison cell in the table.
Click the Design tab.
Click the Insert Slicer button.
You can besides click the Insert tab, then click Slicer.

The Insert Slicers dialog box appears. All the column headings in the table are listed here.
Select the columns you want to utilize every bit slicers.
A carve up slicer will exist created for each column that's selected.
Click OK.

The slicers announced in the worksheet. Y'all tin can now move or resize them as needed.

Filter with a Slicer

Later on a slicer is created, it appears on the worksheet alongside the table. The slicers volition be layered on tiptop of one another if at that place is more than than 1, but they can hands be repositioned.

Select the values you desire to include in the filter.
Concord downwardly the Ctrl fundamental to select multiple filters.

The table is filtered to show just the selected value(southward).

While holding downwards the Ctrl central, merely click the value again to end filtering the selected data.

Clear and Remove a Slicer

Earlier you delete a slicer from a worksheet, brand sure you articulate it. Deleting a slicer doesn't clear the filter.

Click the Clear Filter push.
All the filters are cleared, just the Slicer remains on the worksheet.
Right-click the slicer.
Select Remove "Filter name".

Click the slicer and press the Delete key.