About This Shortcut
This shortcut toggles filters on and off for a range of data. It works on tables or filtered lists, and it's a fast way to clear filters - just turn autofilter off, then on again to reset all filters.
Note: in Excel 2016, this shortcut doesn't appear to work if slicers are on the worksheet.
The videos below demonstrate this shortcut.