An Excel slicer is a button-style filter that sits on top of a table or PivotTable. Click a button, and the data behind it narrows to the value you picked. No drop-down arrows. No clicking through long lists. You see the active filter on screen, which makes slicers the friendliest way to give a non-Excel user control over a report.
Slicers shipped in Excel 2010 for PivotTables, then rolled out to ordinary tables in Excel 2013. They work on Windows, macOS, and Excel for the web. The look is consistent across versions, although the formatting options on Mac are a little leaner. If you can build a table or a PivotTable, you can build a slicer in about ten seconds.
This guide walks through inserting a slicer, connecting one slicer to several PivotTables, styling the buttons, and the small things that catch people out, like blank tiles and the difference between a slicer and a timeline. By the end you should be able to drop a slicer on a dashboard and trust it to behave.
Think of a slicer as a visible filter. Behind the scenes Excel is running the same engine that powers the filter drop-downs on a table header. The difference is presentation. Each unique value in your column becomes a clickable tile. The tile lights up when selected and greys out when it is not. Multi-select is a single click on the tri-state icon in the slicer header.
Because the filter is exposed, anyone opening the workbook can see what they are looking at. That sounds small, but it removes a constant source of confusion. People reading a filtered report often forget that filters are even applied. A slicer reminds them. The selected region is right there, sitting next to the chart.
Slicers also let you control more than one object at once. A single Region slicer can drive three PivotTables, two PivotCharts, and a CUBE-formula KPI card. You wire the connection through Report Connections, and any click updates everything that listens. That is the move that turns a sheet full of summaries into something that feels like a dashboard.
Click any cell in your table or PivotTable, open the Insert tab on the ribbon, click Slicer in the Filters group, tick the columns you want, and click OK. Three clicks plus the column choices. The slicer drops onto the sheet ready to use, and you can drag it anywhere on the worksheet to fit your dashboard layout.
The fastest path is also the simplest. Click any cell inside a table or PivotTable. Open the Insert tab on the ribbon. Find the Slicer button in the Filters group, and click it. A small window lists every column you can use. Tick the columns you want, click OK, and Excel drops the slicers onto the sheet.
If you are working inside a PivotTable, the contextual ribbon will also show a Slicer button under PivotTable Analyze. Same result. For ordinary tables, you can right-click the column header and choose Insert Slicer from the menu. The right-click route is the one most regulars use because it skips the long ribbon hunt.
Each slicer pulls its tiles from the unique values in the source column. Numeric columns work fine, but think about cardinality first. A column with 600 distinct customer IDs makes a slicer that is essentially a scrollable phone book. Reserve slicers for categorical fields like Region, Department, Year, Product Line, or Status, where the option count stays under thirty or so.
The label across the top of the slicer. Right-click the slicer, open Slicer Settings, and type a friendlier caption. You can also hide the header entirely if you want a cleaner dashboard look without losing the buttons themselves.
One button per unique value in the source column. Click to select, Ctrl+click to add to a selection, or use the tri-state multi-select icon in the slicer header to toggle multiple values at once without holding any keys.
The funnel icon in the top right of the slicer header. One click resets the slicer to show every value again and refreshes any PivotTables or charts that were listening to the slicer through Report Connections.
Visible when the slicer is selected. Drag the corners to change the size, or open the Slicer tab on the ribbon and set Columns and Height precisely. The Columns setting is the most useful tool for making slicers fit dashboards.
Once a slicer is on the sheet, the Slicer tab appears whenever the slicer is selected. From there you can change the caption, the number of columns of buttons, the row height, the overall slicer height, and the colour theme. The Columns setting is the single biggest space saver. Set Columns to 4 and what was a tall narrow stack becomes a compact grid that fits at the top of a dashboard.
Built-in slicer styles ship with the workbook, and you can build your own. To make a custom style, open the Slicer Styles gallery, right-click any style, and pick Duplicate. Excel opens a dialog where you can paint each state separately, including Selected With Data, Unselected With No Data, and Hovered. Save the style and it lives in the workbook for reuse.
Right-click any slicer and choose Slicer Settings to control the smaller details. You can hide the header, sort buttons descending, push empty values to the bottom, or hide tiles for items that no longer appear in the source data. The Hide Items With No Data option is the one that prevents stale or empty buttons from cluttering the layout when you refresh the underlying query.
Click inside the PivotTable, open PivotTable Analyze on the ribbon, click Insert Slicer, pick the columns, and click OK. The slicer filters that PivotTable only and ignores anything else on the sheet. Best for simple summary reports where the user wants control over a single view without the complexity of connected objects.
Insert the slicer once, then right-click it and choose Report Connections. Tick every PivotTable that should respond to the slicer. All connected PivotTables refresh together on every click, which gives a dashboard the feel of a single coordinated tool. This is the layout most production dashboards use.
Click inside the table, open Table Design on the ribbon, and click Insert Slicer. Table slicers filter the table rows and any chart bound to the table through a structured reference. Report Connections is not available for table slicers, so the slicer drives one table at a time without the multi-object wiring.
Slicers control PivotTables through Report Connections. Right-click the slicer and choose Report Connections, or click Report Connections on the Slicer tab. A list of every PivotTable in the workbook appears, with a checkbox next to each one. Tick the PivotTables that should respond, click OK, and the slicer now broadcasts to all of them.
Two rules make this work cleanly. First, every PivotTable you want to link must share the same source. If they were built from different ranges or different queries, Excel will not let you connect them, because the slicer values would not line up. Second, the column you sliced on must exist in each PivotTable's source. Same data model, same field, same values.
The Power Pivot data model removes the first constraint. If your tables sit inside a single model, a slicer on a dimension table will filter every PivotTable that touches that dimension, even when those PivotTables show measures from different fact tables. That is how serious financial dashboards stay consistent across a dozen reports without endless wiring.
Slicers work on ordinary Excel tables too, the kind you create with Ctrl+T. Click inside the table, open Table Design, and click Insert Slicer. The interface is identical. The slicer filters rows in the table, hides non-matching records, and updates any chart that reads from a TABLE or SUBTOTAL reference.
Table slicers do not have Report Connections, because tables are not part of the PivotCache. They drive one object at a time. If you need a slicer that controls both a table and a PivotTable, build a PivotTable from the same table source and run everything through the PivotTable layer instead. It is the cleaner path.
A neat use of table slicers is data entry sheets. Put a slicer on a Status column and the data entry team can flip between Open, In Review, and Closed without touching the filter drop-down. Combine the slicer with a freeze pane and conditional formatting, and a plain table starts to look and behave like an internal app. Pair the trick with named ranges and an Excel VLOOKUP lookup column for the polish.
Excel has three visual filter controls, and people mix them up. Slicers handle any data type but excel at categorical fields. Timelines work only on date columns and present a slider you can drag across months, quarters, or years. The classic filter drop-down is built into every table and PivotTable header.
Use timelines when the user wants a continuous date range. Use slicers when the user picks from a fixed list. The drop-down filter is for power users who already know which values they need. The slicer is for the rest of the audience. A typical dashboard pairs one timeline with two or three slicers, all wired to the same set of PivotTables.
Both timelines and slicers can be locked so that users cannot move or resize them. Right-click the object, choose Size and Properties, and tick Disable resizing and moving. Combine that with sheet protection that leaves the slicer unlocked, and end users can still click buttons even though everything else is read-only.
Working with a fast dashboard means thinking about layout, spacing, and the click experience. Group related slicers together and place them across the top, where users expect controls. Keep the slicer captions short. Region beats Sales Region. Year beats Calendar Year. Long captions force narrow tiles, which look cramped.
If you want a clear button without scripting, add a small VBA macro or assign a shape to call SlicerCaches(name).ClearAllFilters. The technique is documented across community sites and works in any desktop edition. On the web, the clear-filter icon already sits in the slicer header, so the workaround is unnecessary.
Slicers also play well with the new dynamic array functions. Build a FILTER formula that reads a hidden cell driven by a slicer, and the array spills the right rows automatically. The combination is how modern Excel users build interactive reports without touching the data model, and it is worth practicing alongside the formula skills covered in INDEX and MATCH and XLOOKUP.
The most common issue is greyed-out tiles for values that no longer exist. Refresh the PivotCache and the ghosts usually clear. If they linger, open PivotTable Options, switch to Data, and set Retain items per field to None. Then refresh once more. The slicer rebuilds clean.
Another common stumbling block is connecting slicers across PivotTables that look related but are not. If Report Connections shows nothing, the PivotTables are based on different sources. Recreate one from the other, or move both to a shared data model. The shared source rule is strict for a reason: the slicer cannot guarantee its values match otherwise.
Slicers occasionally disappear in protected sheets. The fix is to right-click the slicer, choose Size and Properties, and untick Locked under Properties before turning on protection. Excel for the web has a separate locking model, and slicers stay clickable as long as the sheet permission allows editing in that range. The workflow is similar to managing protected ranges next to a conditional formatting formula setup.
A good test of a finished slicer is the five-second rule. Open the dashboard. Show it to a colleague who has never seen the workbook. Ask them to narrow the report to a single region for the last quarter. If they can do it without help, the slicer is doing its job. If they hesitate, the captions are wrong, the layout is cluttered, or the colour contrast is too low.
Practice slicers in small steps. Build a table of 200 rows with three categorical columns. Add slicers to all three. Build a PivotTable from the same data. Connect the slicers to the PivotTable through Report Connections. Resize each slicer to match the grid. Save the workbook and reopen it. The slicers should keep their selections, their styles, and their connections through the round trip.
Then expand. Add a second PivotTable that shares the source. Connect the same slicer to both. Add a PivotChart and watch it move when you click a tile. Drop in a measure card built from CUBEVALUE that reads the same slicer selection. Each piece teaches a new wiring point. By the time you are wiring four objects with one slicer, dashboards stop feeling intimidating.
Slicers are not the only tool for filtering, but they are the most visual and the most user-friendly. The buttons signal intent. The selection state is obvious. The layout choices give designers room to make a clean report. For most non-technical audiences, slicers are the right answer, and the practice questions and worked examples on this site cover dozens of related techniques you can layer on top.
Slicers are clickable, but they are also fully keyboard accessible. Tab into the slicer with the Tab key. Use the arrow keys to move between tiles. Hit Space or Enter to select or deselect. Alt+S clears the slicer. These shortcuts matter for users on small laptops who do not want to keep reaching for the mouse, and they matter for accessibility audits, where every interactive element must be keyboard navigable.
Screen readers in modern Excel announce slicer tiles by name and read out the selection state. The caption you choose in Slicer Settings becomes the accessible name for the entire control, which is one more reason to keep captions clear. A slicer called Region reads better than one labeled SalesRegionFinal2024 when a screen reader gets to it. The small detail also helps when colleagues ask what the control does.
If you build dashboards for an audience that includes colour-blind users, choose a slicer style that distinguishes the selected state with more than colour. The built-in Light and Dark themes already vary in weight and border style, but custom styles can drop that distinction by accident. Test the slicer with a colour-blind simulator before you ship the workbook, the same way you would for a chart. The discipline travels well to other visual filters on a dashboard.
Once a slicer layout works for one report, you can lift it into a template. Save the workbook as an .xltx file or copy the dashboard sheet into a fresh workbook. Slicers carry their connections, styles, and settings with the sheet. Just remember that Report Connections only works against PivotTables in the same workbook, so you may have to reconnect after a copy if the destination workbook has separate PivotTables.
Report packs that ship to multiple regions or business units often use one master slicer per dimension. The pack file holds every PivotTable, and a small set of slicers across the top drives every page. Users open the file, click the region or the product line they care about, and every page reflects the choice. The setup beats sending out twenty separate filtered exports, and it is a natural extension of the skills you build while learning Excel PivotTable and PivotChart basics.