Shortcut keys
WindowsCtrl + Shift + L
MacCmd + Shift + F
Ribbon path
Data → Filter
What it does
Add or remove filter dropdowns on your data range. Click the dropdown arrows to filter by value, color, or condition.
How to use this shortcut
- Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
- Press the shortcut keys shown above for your platform.
- Confirm any dialog options if Excel opens a menu or prompt.
FAQ
What is the Excel shortcut for toggle autofilter?
On Windows, use Ctrl + Shift + L. On Mac, use Cmd + Shift + F.
Where is toggle autofilter in the Excel Ribbon?
The Ribbon path is Data → Filter.
What does toggle autofilter do in Excel?
Add or remove filter dropdowns on your data range. Click the dropdown arrows to filter by value, color, or condition.