Charts & PivotTables · ~1 min read

Excel Slicers: Filter PivotTables with Buttons

Add slicers and timelines to filter with a click.

Video link coming soon
What you will learn

Step by step

1. Buttons, not lists

Filtering a PivotTable with drop-down lists is slow. A slicer gives you buttons: one click, and the report shows one region.

You will add a slicer, pick one or two regions, filter by month with a timeline, and see what a slicer cannot reach.

Excel Slicers: Filter PivotTables with Buttons: Buttons, not lists
Buttons, not lists

2. The PivotTable

First a PivotTable at F1: Control and T, Enter, Alt, N, V, T, then tick Rep and Sales.

Shortcut: Ctrl + T

Excel Slicers: Filter PivotTables with Buttons: The PivotTable
The PivotTable

3. Add a slicer

With a cell inside the PivotTable selected, insert a slicer: Alt, N, S, F.

Press Down to reach Region, Space to tick it, and Enter.

Excel Slicers: Filter PivotTables with Buttons: Add a slicer
Add a slicer

4. One click

One button per region. Click North. Only Ava and Emma are left: eight thousand one hundred.

Hold Control and click South to add it. The buttons you picked stay colored, the others turn grey.

To see everything again, click the clear filter icon in the slicer's corner.

Quick pause: if your reports just got clickable, a like really helps the channel. Next, months.

Excel Slicers: Filter PivotTables with Buttons: One click
One click

5. A timeline

For dates there is a special slicer, the timeline. Click in the PivotTable and press Alt, N, S, T, then Space and Enter.

Click June. The report shows June only: Ava and Noah, three thousand eight hundred.

Excel Slicers: Filter PivotTables with Buttons: A timeline
A timeline

6. What slicers miss

Now the trap. Next to the report, in I1, type equals SUM of C2 to C13.

Twenty two thousand seven hundred, the whole year. Slicers and timelines filter only the PivotTable. Formulas on the source data never see them.

So any number that should follow the buttons must come from the PivotTable itself.

=SUM(C2:C13)
Excel Slicers: Filter PivotTables with Buttons: What slicers miss
What slicers miss

7. Recap

Recap: Alt, N, S, F adds a slicer, Control-click picks more than one, Alt, N, S, T adds a timeline, and only the PivotTable follows them.

In the next lesson, you will put PivotTables, charts and slicers together into a simple dashboard.

Which field would you put on a slicer in your own reports? Tell me in the comments.

Excel Slicers: Filter PivotTables with Buttons: Recap
Recap
What do you want to learn next? Tell us in the comments on YouTube: your requests decide the next tutorials.

← Previous tutorial: PivotTable Grouping and Calculated Fields
Next tutorial: Build a Simple Excel Dashboard (Beginner Friendly) →