Excel Course
Slicers in Excel
Slicers are the interactive filter buttons that make a dashboard genuinely usable. Instead of asking someone to navigate PivotTable filter dropdowns buried in a header row, slicers give them a clean, visible set of buttons they can click to instantly filter every connected chart and table on the page. A well-placed, well-styled slicer panel transforms a static report into a self-service analytics tool. This lesson covers inserting slicers, connecting them to multiple PivotTables, formatting them to match a dashboard design, and using Timeline slicers for date-based filtering.
Inserting a Slicer
Slicers can be inserted from a PivotTable, a data model PivotChart, or an Excel Table. The most common approach in dashboard work is inserting from a PivotTable — the slicer appears as a floating panel that can be positioned anywhere on the sheet.
Inserting a slicer from a PivotTable:
Click anywhere inside the PivotTable
PivotTable Analyze tab → Filter → Insert Slicer
Tick the field(s) you want as slicers → OK
Each ticked field creates a separate slicer panel
Inserting a slicer from an Excel Table:
Click inside the Table
Table Design tab → Tools → Insert Slicer
Same process — tick fields → OK
Inserting a Timeline slicer (for date fields):
PivotTable Analyze tab → Filter → Insert Timeline
Select the date field → OK
Timeline shows months/quarters/years as a scrollable bar
Slicer behaviour:
Clicking a button filters the connected PivotTable to that value
Ctrl+click selects multiple values (OR logic)
The multi-select button (≡) in the slicer header toggles multi-select mode
The clear filter button (✕) in the top-right resets the slicerConnecting a Slicer to Multiple PivotTables
By default, a slicer only controls the PivotTable it was created from. On a dashboard with multiple charts and tables, you need one slicer click to filter everything simultaneously. This is done through Report Connections — a two-click process that links the slicer to as many PivotTables as you want.
Connecting a slicer to additional PivotTables:
Right-click the slicer → Report Connections
A dialog lists every PivotTable in the workbook
Tick every PivotTable that should respond to this slicer → OK
Requirements for a slicer to connect to a PivotTable:
The slicer field must exist in the connected PivotTable's data source
Both PivotTables must share the same data model or the same source table
PivotTables from different unrelated sources cannot share a slicer
Checking connections:
Right-click the slicer → Report Connections → review ticked tables
A slicer with no connections (all unticked) affects nothing — check this
if a slicer click does not seem to filter the dashboard
Disconnecting a slicer from one PivotTable:
Right-click → Report Connections → untick the PivotTable → OK
The slicer still works for the remaining connected tablesFormatting Slicers
The default Excel slicer style clashes with almost every custom dashboard design. Fortunately, slicers have full formatting control through Slicer Styles — either by modifying an existing style or duplicating one and customising it. The key properties to change are: selected button colour, unselected button colour, header appearance, and the slicer border.
Applying a built-in slicer style:
Click the slicer → Slicer tab → Slicer Styles gallery
Hover to preview · click to apply
Light styles work best on light dashboards; dark styles on dark
Creating a custom slicer style:
Slicer tab → Slicer Styles → right-click any style → Duplicate
Name your style (e.g. "Dashboard Brand")
Double-click any Slicer Element to format it:
Whole Slicer → set border: None
Selected Item with Data → Fill: brand colour (#7c3aed), Font: white bold
Unselected Item with Data → Fill: white, Border: light grey, Font: #475569
Header → Fill: transparent, Font: uppercase small grey
Click OK → apply to slicer
Key slicer size settings (Slicer tab):
Buttons: Height and Width → match to consistent grid (e.g. 0.3" height)
Columns: set to 2 or more for horizontal layouts (e.g. months in 2 columns)
Position and Size: X/Y position → use for precise placement on dashboard
Removing the slicer border entirely:
Right-click slicer → Format Slicer → Border → No line
This makes the slicer look like it is part of the sheet, not a floating objectThe Columns setting inside slicer properties is underused. For a Region slicer with four values, setting Columns to 4 displays all four buttons in a single horizontal row rather than a vertical list — perfect for a top filter bar. For a month slicer with twelve values, setting Columns to 6 gives two compact rows of six. Adjust the slicer width to match.
Timeline Slicers — Date-Based Filtering
A Timeline slicer is a special slicer designed specifically for date fields. Instead of a list of buttons, it shows a scrollable time bar where you can drag to select a date range — by day, month, quarter, or year. It is the most intuitive way to let dashboard users filter by time period without typing dates.
Inserting a Timeline slicer:
Click inside the PivotTable
PivotTable Analyze → Filter → Insert Timeline
Select the date field → OK
(The field must be a proper date/datetime type — text dates will not appear)
Timeline granularity control:
Top-right dropdown in the Timeline: Days / Months / Quarters / Years
Change this to match the reporting period your audience uses
Connecting Timeline to multiple PivotTables:
Right-click the Timeline → Report Connections → same process as regular slicers
A Timeline can be connected to PivotTables using the same date field
Formatting the Timeline:
Timeline tab → Timeline Styles → choose or customise
The selected period colour, handle colour, and header can all be modified
in a duplicate Timeline Style (same process as regular slicer styles)
Practical tip — combining Timeline with dimension slicers:
A dashboard typically has:
- One Timeline at the top (date range selection)
- 2–3 dimension slicers beside it (Region, Category, Segment)
All connected to the same set of PivotTables
This combination covers almost all ad-hoc filtering needsOne limitation to be aware of: Timeline slicers only work with fields that Excel recognises as proper date values — not text strings formatted to look like dates. If the date column came from Power Query, check that it was typed as Date in the query editor before loading to the model. Text dates will simply not appear in the Insert Timeline dialog.
Slicer Panel Design — Positioning and Layout
Where and how slicers are positioned on the dashboard matters as much as the data they filter. A slicer panel that is hard to find, inconsistently sized, or visually cluttered will reduce dashboard usability even if every connection is technically correct.
Recommended slicer panel layout patterns:
Top bar (most common):
Place all slicers in a horizontal strip across the top of the dashboard
Keep height consistent — all slicers the same row height
Order: most important filter first (usually Date/Region) on the left
Separate slicers from the content zone with a thin line or extra row gap
Left panel:
Stack slicers vertically on the left side in a fixed-width column
Works well when slicers have many values (10+ buttons each)
Dedicate a specific column width (e.g. columns A–C) to the slicer panel
Slicer sizing best practices:
Set all slicers to the same width for visual consistency
Single-value slicers (Region, Year): set Columns to 4 for horizontal layout
Many-value slicers (Product, Customer): use 1 column vertical list with scroll
Grouping related slicers visually:
Place a label above the slicer group: "FILTERS" in small uppercase grey text
Add a subtle background shape behind the slicer group to create a zone
Insert → Shapes → Rectangle → fill with light grey (#F1F5F9) → Send to Back
This makes the filter area visually distinct from the data area🟠 Practice
Q1. You have a Region slicer connected to PivotTable 1 but your dashboard also has PivotTable 2 and PivotChart 3. How do you make the slicer control all three?
Q2. You want a Region slicer with four values (North, East, West, South) to display as a single horizontal row of four buttons instead of a vertical list. Which slicer setting do you change?
Q3. A Timeline slicer is not appearing for a date column in your PivotTable. What is the most likely cause?
🟣 Quiz
Q1. A slicer is connected to PivotTable A and PivotTable B. You click "North" in the slicer. PivotTable A filters correctly but PivotTable B does not change. What is the most likely cause?
Q2. What is the difference between a regular slicer and a Timeline slicer?
Q3. You want to visually separate the slicer filter zone from the chart area on your dashboard. What is a simple way to do this without creating a full border or frame?
Next up — PivotTables and PivotCharts, where we build the full analytical foundation of a dashboard — mastering PivotTable layout, grouping, calculated fields, and connecting PivotCharts to create a chart panel that responds to every filter.