Toggle Filter in Excel (Ctrl+Shift+L / ⌘⇧F)
Click any cell in your data, then press Ctrl+Shift+L on Windows or ⌘⇧F (Command+Shift+F) on the Mac to turn filter dropdowns on or off.
| Action | Mac | Windows | |
|---|---|---|---|
| Toggle AutoFilter on/off | ⌘⇧F | Ctrl+Shift+L | |
| Open the filter menu on a cell | ⌥↓ | Alt+↓ |
Turn filters on in one keystroke
Click any cell inside your table, then press Ctrl+Shift+L on Windows or ⌘⇧F on the Mac. Excel adds dropdown arrows to each header; press the same shortcut again to remove them.
Open a column's filter menu
With filters on, select a header cell and press Alt+↓ (Windows) or ⌥↓ (Mac) to open that column's filter list from the keyboard.
FAQ
What is the filter shortcut in Excel?
Press Ctrl+Shift+L on Windows or ⌘⇧F (Command+Shift+F) on the Mac to toggle AutoFilter.
How do I open a column's filter menu with the keyboard?
Select the header cell and press Alt+↓ on Windows or ⌥↓ on the Mac.
Does the shortcut remove filters too?
Yes — pressing it again turns the filter dropdowns off.