Quick, clean, and to the point

Clear slicer filter

Windows shortcut 
Mac shortcut 

This shortcut clears or resets the filter for a selected slicer. You must select the slicer first before using the shortcut.

Note: if you want to reset all filters applied to an Excel Table at the same time, you can use a shortcut to toggle filters off then on again.

Related videos

The videos below demonstrate this shortcut.
In this video, we'll look at how to add a slicer to a pivot chart. Slicers provide a powerful way to filter data interactively, and they are a key building block of many dashboards.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.