ShortcutdrillExcel shortcuts / editing / Turn filters on and off
Turn filters on and off in Excel: Ctrl+Shift+L (Mac: Cmd+Shift+F)
| Windows | Ctrl+Shift+L |
|---|---|
| Mac | Cmd+Shift+F |
| Group | editing |
Drill: Turn on filters. Pro drill. Twenty-five drills are free.
What it does and when to use it
Ctrl+Shift+L adds filter buttons to the header of the current region, and removes them when pressed again. Alt+Down on a header cell opens the filter list without the mouse.
The common mistake
Pressing it with the active cell outside the data, which puts a filter on an empty cell.
Related shortcuts
- Undo Ctrl+Z
- Fill down Ctrl+D
- Fill right Ctrl+R
- Clear the selection Delete
- Delete the row Shift+Space, Ctrl+-
- The printable cheat sheet
Questions
How do I clear all filters?
Alt, A, C clears the filters while keeping the buttons. Ctrl+Shift+L twice removes and re-adds them, which also clears.
Learn it by pressing it
Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.
Start the drill