Excel® 2013 On Demand

Using Slicers to Filter a Table

Instead of using the AutoFilter menu each time you want to filter data in a table, you can create a slicer (New!) button that enables you to quickly filter data in a table with a single click. Each slicer is shown on the screen with button labels that indicate the data being filtered. A slicer includes a header, filtering buttons, a Clear Filter button, a scroll bar, and move and resize controls. You can have more than one slicer and move them around on the worksheet. You can also format slicers with styles to match the look and feel of your worksheet and easily set options to customize slicer settings.

Create, Format, and Delete a Slicer

Click any data field in the table for which you want to create a slicer. ...