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.

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass