Excel slicers: filter data faster and more clearly

A spreadsheet with a few hundred rows is a data set. The same spreadsheet in a management meeting is a report, and the two have very different requirements. A filter drop-down is fine when you are the one doing the analysis. It is much less useful when somebody else is trying to answer a question in front of an audience, because the current filter state is hidden inside a menu nobody has opened.

4 September 2026 7 min read

A slicer moves the filter out of the menu and onto the page. It is a panel of labelled buttons — one per value in a chosen field — that filters the connected data when you click it, and stays visibly highlighted afterwards so the current view is obvious to everyone looking at the screen.

That second half matters more than the speed. The reason reports get misread in meetings is rarely that the numbers are wrong. It is that somebody is looking at a filtered figure and does not realise a filter is applied.

What a slicer actually is

Take a small asset register — device, department, location, status. To see only the Pretoria devices with a drop-down, you open the Location filter, clear the current selection, tick Pretoria and apply. To do the same with a slicer, you click Pretoria.

A slicer on Location, with Pretoria selected. The connected table shows only the matching rows, and the active filter stays visible on the page rather than inside a menu.

The saving on a single filter is a few seconds. The saving across a forty-minute review meeting, with someone changing the view a dozen times while talking, is the difference between a report people interrogate and one they sit through.

Where slicers work

Slicers connect to structured objects, not to arbitrary ranges. That is the one prerequisite worth knowing before you start:

Excel Tables — a range formatted as a Table (Insert › Table, or Ctrl+T). Slicers were extended to Tables in Excel 2013.
PivotTables — the original use, and still where slicers earn the most.
PivotCharts — a slicer filters the PivotTable behind the chart, so the chart redraws with it.
Dashboards — which in Excel simply means several of the above arranged on one sheet.

A plain range will not accept a slicer. If the Slicer button is greyed out, the data has almost certainly not been converted to a Table yet, and that conversion is worth doing regardless — it is what makes formulas and PivotTables pick up new rows automatically.

Adding a slicer

The path is the same for a Table and for a PivotTable on Windows and Mac — select the object, then insert the slicer:

Click inside the Table or PivotTable

The selection is what tells Excel which object the slicer will filter. Click a single cell inside it; you do not need to select the whole range.

Insert › Slicer

On the Insert tab, choose Slicer. For a Table the Table Design tab carries the same command as Insert Slicer, and for a PivotTable in Excel for the web it sits on PivotTable Analyze.

Choose the fields

Tick the columns you want to filter by. Each one becomes its own slicer panel, so choose deliberately rather than ticking everything.

Select OK

The slicers appear on the sheet, already connected to the object you selected.

Position and size them

Drag them where the reader will look first — usually above or beside the report, not below it. The Slicer tab sets the number of columns of buttons, the button size and the style.

For date fields specifically, Excel has a purpose-built alternative. PivotTable Analyze › Insert Timeline gives a sliding date control that filters by year, quarter, month or day — usually a better answer than a slicer with sixty month buttons in it.

Selecting more than one value

A single click replaces the current selection. To build a combined view — Finance and Operations together, say — hold Ctrl on Windows or Command on a Mac while clicking. The slicer header also carries a multi-select toggle, which turns every click into an add-or-remove without the modifier key; useful when a report is being driven on a touchscreen or projector.

The other header control is Clear Filter, which reselects everything and returns the report to its full view. It is worth pointing out explicitly when you hand a workbook over, because a report left in a filtered state is the most common way an Excel dashboard gets misread.

Why slicers suit dashboards

Consider a service desk summary — the figures below are illustrative, not drawn from any Define IT client — where a month of activity comes to 246 logged calls:

Open

184

Resolved

Pending

Add slicers for Region, Client, Priority, Status and Month, and that single summary answers a great many questions without being rebuilt. Select Gauteng and every figure narrows to Gauteng. Add High priority and you have the specific view somebody just asked for, produced in two clicks while they watch.

The alternative — a separate tab or a separate file for each recurring question — is how a reporting pack grows to fourteen sheets that all have to be refreshed by hand and all disagree slightly by month end.

One slicer, several PivotTables

This is the capability that turns a sheet of PivotTables into an actual dashboard. A slicer can drive more than one PivotTable at once, so a single Region selection updates every panel on the page together.

One Region slicer connected to five PivotTables. Selecting Gauteng updates all of them at once, so the panels always describe the same filtered population.

Right-click the slicer and choose Report Connections on Windows and Mac — in Excel for the web the equivalent lives under Slicer Settings as PivotTable Connections — then tick the PivotTables it should control.

Slicers or filters?

This is not a competition, and the honest answer is that a good workbook uses both.

Traditional filters

Compact — they live in the header row and take no space
Strong for detailed, exploratory analysis
Better where screen space is tight
Faster for someone who already knows the data

Slicers

Visual — the available values are on the page
The current selection is obvious to everyone
Can be positioned anywhere in the report
Better for dashboards and for handing a report to someone else

A practical split: slicers on the two or three fields the audience will actually change, header filters left in place for whoever maintains the workbook and needs to dig.

Keep the slicer set small

Adding more slicers does not make a dashboard better. Every control is something a reader has to interpret, and a wall of twelve panels does a good impression of a settings screen.

A monthly operational report might expose Month, Region, Client and Status, and nothing else — even where the source data carries thirty columns. The other twenty-six are still there for anyone who needs them; they are simply not competing for attention.

Build the report for the person using it

Whoever builds the workbook knows where the data came from, which sheet is the source, what the PivotTable is grouped by and which filters are already applied. None of that is visible to the executive, manager or client who receives it — and none of it is their job to reconstruct.

The shift is from “here is the spreadsheet” to “here is the information — choose what you want to see.”

That is a design decision rather than a technical one, and it costs about ten minutes. Put the slicers where the eye lands first, label them in business terms rather than column names, clear the filters before sending, and the same file stops generating questions about how to read it.

The Define IT perspective

Excel endures because it spans an unusual range — a quick calculation at one end, operational reporting and interactive dashboards at the other. Most organisations are licensed for the whole of that range and using a narrow slice of it.

The gap is rarely a missing product. Tables, PivotTables, PivotCharts, slicers and Power Query are already installed, and together they turn a manually maintained spreadsheet into something closer to a reporting tool: structured at the source, refreshed rather than rebuilt, and readable by the person it is sent to.

That is the work we do around Microsoft 365 — not replacing what already functions, but making better use of the capability an organisation is already paying for, and putting structure under the reports that people actually depend on.

Key takeaways

A slicer filters a Table, PivotTable or PivotChart from labelled buttons on the page, and keeps the active selection visible.
Insert › Slicer works for both Tables and PivotTables; the data must be a Table or PivotTable first, not a plain range.
Ctrl or Command while clicking selects several values; the header carries a multi-select toggle and a Clear Filter control.
Report Connections links one slicer to several PivotTables — but only where they share the same data source.
For dates, an Insert Timeline control usually beats a slicer with sixty buttons in it.
Expose the two or three fields the audience will actually change, not every column in the source.