Clear Slicer Filter in Excel (Alt + C)
The Clear Slicer Filter shortcut allows you to quickly remove any filter applied via a slicer in a PivotTable or table. This helps you restore the full dataset without manually clicking the slicer clear button.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Alt + C | Option + C |
What Does This Shortcut Do?
Pressing this shortcut clears the filter applied by the selected slicer, displaying all data rows again.
How to Use the Shortcut
- Click on the slicer you want to clear
- Press Alt + C (Windows) or Option + C (Mac)
- The filter applied by the slicer will be removed
Tips & Best Practices
- Useful for quickly resetting multiple PivotTables connected to the same slicer
- Combine with other slicer shortcuts to speed up PivotTable analysis
- Works best when slicers are visible and selected
FAQ
- Q: Can I clear multiple slicers at once?
- No, this shortcut only clears the selected slicer. Use it on each slicer individually.
- Q: Does it work on non-PivotTable slicers?
- Yes, any slicer connected to a table or PivotTable can be cleared using this shortcut.