Standard Excel filters have their place for specific workflows, but they become a headache when you need to explore data quickly. Instead of burying criteria in nested menus, you can use slicers to create an instant, visual control panel.
Standard Excel drop-down filters are slowing you down
The hidden cost of clicking
We’ve all done it. You click the tiny downward arrow at the top of a column, uncheck “Select All,” scroll through a long list to find the few items you actually care about, and click “OK.” It works—but it’s a clunky, menu-heavy way to interact with data. The moment you click away, your filtering choices disappear from view, leaving you guessing what is currently applied unless you reopen the menu.
The problem gets worse when you start layering filters across multiple columns. Filter by country, then by department, then product, and suddenly your spreadsheet is dotted with small funnel icons that are easy to misinterpret.
That’s not to say traditional drop-down filters don’t have their place. If you’re dealing with a column containing hundreds of unique entries—like specific part numbers or people’s names—the built-in search box is often the quickest way to type a keyword and find exactly what you need. Traditional filters are best for this kind of granular, text-based search.
However, they struggle to communicate state. Yes, they let you narrow your data, but they don’t make it obvious what is currently active at a glance. If you frequently toggle between broad, high-level categories rather than searching for specific text strings, hiding those choices inside a menu makes your spreadsheets much harder to read, share, and audit—especially when multiple people are collaborating on the same sheet.
Slicers turn your spreadsheet into a visual dashboard
Better visibility for your data
Slicers solve the biggest weakness of standard filters by bringing your options out into the open. Instead of hiding controls inside drop-down menus, slicers turn your categories into large, clickable buttons that sit directly on the worksheet.
Want to view U.S. sales? You just click it. Want to include multiple departments? You can select multiple buttons at once by holding Ctrl as you click, or clicking the Multi-Select toggle at the top of the panel. Want to reset everything? One click clears the slicer’s selection.
This persistent layout turns your dataset into something closer to an interactive dashboard than a static grid. Another advantage is responsiveness. As soon as you click an option, the data updates. If a category has no matching records based on your current selections, its button automatically greys out. That feedback loop makes it much easier to engage in visual data slicing without running into dead ends.
- OS
-
Windows, macOS, iPhone, iPad, Android
- Free trial
-
1 month
Microsoft 365 includes access to Office apps like Word, Excel, and PowerPoint on up to five devices, 1 TB of OneDrive storage, and more.
You can use slicers on regular tables and PivotTables
Setting up your new workflow
One of the most common misconceptions about slicers is that they only work with complex PivotTables. Thankfully, that’s no longer the case. Modern versions of Excel also support slicers on regular Excel tables, meaning you can use them in everyday spreadsheets.
Here’s how to get started:
- Click anywhere in your data and press Ctrl+T (or click Insert > Table).
- Confirm your range and whether your data has headers.
- Open the Table Design tab, then select Insert Slicer.
- Choose the fields you want to filter, then click OK.
Excel then generates floating panels that you can position anywhere on your worksheet. These panels are fully interactive: you can resize them, rearrange them, and use them to filter your dataset. I like to place them at the top so they’re front and center as soon as you open the worksheet.
The same concept applies to PivotTables (via the PivotTable Analyze tab), where it becomes an effective tool for summarizing and aggregating data dynamically.
Connecting a single slicer to multiple datasets
One control panel for multiple views
Where Excel slicers really start to feel professional is when you link them across multiple PivotTables built from the same core dataset.
To set this up:
- Click anywhere inside one of the PivotTables, and in the PivotTable Analyze tab, click Insert Slicer.
- Select the field you want this slicer to control, and click OK.
- Right-click the slicer, then click Report Connections.
- In the dialog, check the boxes for every PivotTable you want this slicer to control.
Repeat this process for any additional fields you want to control with their own slicers.
Dynamic charts turn your raw data into a living presentation
Visualizing your changes in real time
The app-like experience that slicers bring becomes even more apparent when you add charts into the mix. If you build a chart or PivotChart from a slicer-connected table or PivotTable, it updates automatically as the underlying data is filtered.
In most cases, you don’t need any additional configuration beyond building the chart from a slicer-connected source. When you select an option in your slicer, the underlying data is filtered, and your connected charts are updated instantly.
By pairing a few strategically placed charts with slicer blocks, you can build a fully functional, interactive presentation layer that completely replaces the need for static slide decks.
Your spreadsheets will finally feel like a modern web app
The immediate productivity payoff
Slicers are especially helpful when you share your workbooks with other people. Not everyone is comfortable navigating Excel’s traditional drop-down layout, and these visual buttons eliminate that learning curve entirely. Instead of digging through menus, users interact with clear on-screen controls, making spreadsheets feel more like simple, app-style interfaces.
They also improve clarity during exploration. Because all options are visible at once, anyone opening the file can instantly see the dataset’s dimensions. Since unavailable choices are grayed out based on selections, it’s easy to see how data points interact without constant trial-and-error. This makes slicers a great addition to dashboards, reporting files, and any spreadsheet your team reuses over time.
A simple upgrade with a big payoff
Slicers bring your data logic directly onto the worksheet, where you can see and control it at a single glance. Once you start using them, navigating your data stops feeling like a chore and starts feeling like interacting with a clean, interactive dashboard. When you’re ready to refine the presentation, you can modify slicer styles to match your report design and create a beautifully polished finish.