Exceljet

Quick, clean, and to the point

Slicer

Excel Slicer

A slicer is a control that lets a user filter a Pivot Table or an Excel Table using buttons. A slicer provides the same function as using filter controls to filter a list.  However, instead of drop-down menus, slicers provide large, friendly buttons that are always visible. The buttons are created automatically based on values in the data.

In the example shown, the slicer is set up to filter on the Department field in the data. Because there are five values in the data (Engineering, Fulfillment, Marketing, Sales, and Support) the slicer makes provides buttons with these names.