Slicers are visual filtering tools used with Excel Tables and PivotTables.
They allow you to filter data using clickable buttons instead of dropdown menus.
Slicers make reports interactive and user-friendly.
Why Use Slicers?
- Easy filtering with one click
- Visual and interactive
- Great for dashboards
- Faster than normal filters
- Professional presentation
How to Add a Slicer to a Table
Steps:
- Click inside the Excel Table
- Go to Table Design tab
- Click Insert Slicer
- Select the column(s) you want
- Click OK
A slicer box will appear with clickable buttons.
Example
If your table contains:
| Name | Department | City |
Insert slicer for Department.
Now you can click:
- HR
- IT
- Finance
Only selected department data will be displayed.
Selecting Multiple Items
- Hold Ctrl and click multiple buttons
OR - Enable Multi-Select icon in slicer
Clear Filter
Click the Clear Filter icon (top right of slicer).
Slicer Formatting
Click on slicer → Go to Slicer tab → Choose:
- Different styles
- Change button color
- Adjust number of columns
- Resize slicer box
Customize Slicer Layout
You can:
- Change number of columns (for horizontal layout)
- Resize buttons
- Align multiple slicers
- Rename slicer header
Connecting Slicers to Multiple Tables (Advanced)
Slicers can control multiple PivotTables if they share the same data source.
Important Tips
- Slicers work only with Tables and PivotTables
- Keep slicers neatly aligned in dashboards
- Use clear and meaningful column names
- Avoid too many slicers in small space
Slicers vs Auto Filter
| Auto Filter | Slicer |
|---|---|
| Dropdown menu | Visual buttons |
| Less interactive | Highly interactive |
| Basic filtering | Dashboard-friendly |
Why Slicers Are Important
Slicers make Excel reports interactive and professional.
They are especially useful in dashboards, management reports, and data analysis presentations.
Slicers improve usability and make filtering simple and visually appealing.