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.
About This Shortcut
Use this shortcut to activate a filter that already exists. Excel will then display sorting and filtering options. You must be in the cell that contains the filter (the dropdown arrow) before you use the shortcut.
