Exceljet

Quick, clean, and to the point

Toggle Autofilter

Windows shortcut 
CtrlShiftL
Mac shortcut 
F

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.

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.
Sir your website is awesome. It gave me what I want. Thanks and hope it will help me again when I need it - Atul
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course