How to Use Slicers in Excel

Excel slicers are clickable filter controls for pivot tables, tables, and dashboards. They make reports easier to use because the selected filter is visible on the page instead of buried inside a dropdown.

Slicers are most useful when someone else needs to review the workbook and filter by owner, region, status, category, month, or project without touching the underlying data.

Step-by-step slicer setup

Step 1. Start with a clean table or pivot table

Slicers work best when the source data has one header row and consistent values. For a project dashboard, useful slicer fields might include owner, status, workstream, priority, and month.

Step 2. Insert the slicer

Click inside the pivot table or Excel table, then choose Insert Slicer. Select the fields you want available as clickable filters.

Avoid adding too many slicers. Two or three strong filters are usually better than a wall of controls.

Step 3. Place slicers near the report they control

Put slicers near the top of the dashboard or beside the chart they filter. The reader should understand what changed after clicking a slicer without hunting around the workbook.

Step 4. Connect one slicer to multiple pivot tables

If your dashboard has several pivots using the same data source, right-click the slicer and choose report connections. Connect it to every pivot table that should respond to the same filter.

This is how a dashboard can filter KPI cards, charts, and detail tables together.

Step 5. Use slicers for review questions

Good slicers match the way people review the report:

• owner
• project status
• department
• month or quarter
• customer segment
• sales stage

Bad slicers are fields with hundreds of unique values, like invoice number or task name.

Slicers in project and dashboard workbooks

Slicers are especially helpful in project tracker and Gantt chart workflows when leadership wants to filter by owner, status, phase, or risk level. They also fit sales dashboards, content calendars, expense reviews, and OKR scorecards where the same report needs multiple review views.

For example, a weekly project review can use slicers for Status and Owner, while the source table still holds task, due date, blocker, and next-step detail.

Common slicer problems

The Griddy way

Manual slicer work gets tedious when a dashboard has several pivot tables, summary blocks, and charts that all need to respond to the same filters.

"Add slicers for owner, status, and quarter, connect them to every pivot table, and clean up the dashboard layout."

Griddy can add the controls, connect them to the right tables, and keep the filtered report readable.