Quick, clean, and to the point

Toggle Autofilter

Windows shortcut 
Mac 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.

Related videos

Tip:  Shortcuts for Excel Tables
Excel has great support for shortcuts in tables. Shortcuts for inserting, selecting, and deleting rows and columns all work much better! Watch the video to see how.
Tip: How to build a search box to highlight data
In this video, we use conditional formatting to create an interactive search box to highlight data. This is a nice alternative to filtering, because the information you're looking is highlighted in context, and the search box checks multiple columns at the same time (using concatenation).
Tip: How to display the number of items in a filtered list
In this video, we show you how to add a message at the top of a filtered list that displays total and visible items in the list.
Tip: How to use conditional formatting to check line length
A short video that shows you how to use conditional formatting with the LEN function to highlight text that is too long.