Anyone who has spent time wrangling a large dataset in Excel knows the frustration of dropdown filters that are slow to navigate and difficult to read at a glance. Slicers are Excel’s answer to that problem — a visual, button-based filtering interface that makes it faster to drill into the data you actually need, and easier to see exactly what filters are currently applied. If you’re not using them yet, here’s a full introduction.
What a slicer actually is
A slicer is a visual filter panel that appears on your worksheet as a floating element. It contains one button for each unique value in a chosen column. Clicking a button applies that filter to your table or PivotTable instantly, and clicking multiple buttons applies multiple filters at once. Buttons for values excluded by the current filters appear grayed out rather than disappearing, so you always know what’s in your dataset and what’s being filtered out.
Slicers can be connected to tables, PivotTables, and PivotCharts, and one of their most powerful features is the ability to link a single slicer to multiple PivotTables at once. That means clicking a button in the slicer updates every connected table and chart simultaneously. This makes it easy to build dashboards where one filter selection updates all the visuals at once.
Preparing your data for a slicer
Slicers work with data formatted as an Excel table or a PivotTable, so the first step is making sure your data is structured correctly. If you’re starting from a raw dataset, select any cell within your data range and go to Insert > Table on the Ribbon. In the dialog that appears, confirm that the range is correct, check the box for “My table has headers,” and click OK.
Good table structure makes slicers more useful: each column should have a clear, descriptive header, there should be no blank rows or columns within the data range, and data types within each column should be consistent. A column mixing dates and text, or numbers formatted inconsistently, will produce slicer buttons that are difficult to interpret.
Creating a slicer
With your data formatted as a table, click any cell within it and navigate to Insert > Slicer. A dialog box will appear listing all the column headers in your table. Select one or more fields you want to use as filters — for a sales dataset, for example, you might choose Region, Product Category, and Sales Rep — and click OK.
Excel will place a separate slicer panel on the worksheet for each field you selected. Each panel displays a button for every unique value in that column. You can drag the slicers around the worksheet to position them alongside your table, and resize them by dragging the edges. If you’re building a dashboard that others will use, placing all slicers together above or beside the data makes the interface easier to navigate.
Filtering with slicers
Clicking a button in any slicer instantly applies that filter to the connected table or PivotTable. To select multiple values within a single slicer, hold Ctrl while clicking each button you want to include. To clear a filter from a slicer, click the clear filter icon in the upper-right corner of the slicer panel — it looks like a filter icon with a red X. Multiple slicers work together as intersecting filters: selecting a region in one slicer and a product category in another shows only the rows matching both criteria.
Customizing the look of your slicers
Slicers are functional by default, but they can also be styled to match a worksheet or dashboard aesthetic. Clicking a slicer selects it and activates the Slicer tab on the Ribbon, where you’ll find a gallery of preset styles. Applying a consistent style across all slicers in a dashboard makes the interface feel cohesive and easier to use.
Beyond color, you can adjust the number of columns displayed within a slicer panel using the Columns control in the Slicer tab. For a column with many unique values, displaying buttons in two or three columns rather than one long list makes the panel more compact and easier to scan. You can also adjust the height of individual buttons to make them easier to click on touchscreen devices.
Slicers on PivotCharts
Slicers can also be connected to PivotCharts, giving viewers direct control over what the chart displays. Click any cell in a PivotChart, select Insert > Slicer, choose the fields, and the resulting slicer will filter the chart just as it filters a PivotTable. For presentations or reports where you want readers to interact with the data rather than simply view a static chart, this approach is more engaging than a fixed snapshot.
Slicers don’t require advanced Excel skills to set up, but they make a noticeable difference in how quickly you can explore and present data. Whether you’re building a dashboard for a team, analyzing sales data, or reviewing any dataset with multiple categories, slicers reduce the friction between asking a question about your data and seeing the answer.
Looking to get more out of Excel and the rest of the Microsoft 365 suite? Our team helps businesses configure and optimize their Microsoft tools for real productivity gains. Get in touch to find out what’s possible.
Leave a comment!