What is the shortcut for Toggle AutoFilter?
Windows: Ctrl+Shift+L. Mac: Ctrl+Shift+L.
📊Excel Shortcut
Toggle AutoFilter
Detailed guide to use "Toggle AutoFilter" in Excel
Shortcut Keys
The highlighted keys show where to press. Press the required keys together.
Windows
Ctrl
⇧
L
Windows shortcut: Ctrl+Shift+L
Mac
Ctrl
⇧
L
Mac shortcut: Ctrl+Shift+L
In Action
This shows a representative pseudo-Excel example of what happens after the shortcut runs. The actual Excel UI may differ slightly.
Auto-playing example
Active: A1Selection: A1Sheet: Sheet1Step 1/2
You can scroll the sheet horizontally
↶↷BIUGeneral
Name Box
A1
Formula Bar
fxItem◢ | A | B | C | D |
|---|---|---|---|---|
| 1 | Item | Qty | Price | Total |
| 2 | Pen | 12 | 80 | 960 |
| 3 | Pad | 6 | 120 | 720 |
| 4 | File | 4 | 300 | 1200 |
| 5 | Box | 3 | 450 | 1350 |
Sheet1
Ready100%
Basic Info
- Category
- Other
- Difficulty
- ★★☆(Intermediate)
How to Use
- 1Select the target cell/range if needed
- 2Press the highlighted keys shown above together
- 3Toggle AutoFilter is executed
Practice
Practice this shortcut and build reliable muscle memory.
Usage Tip
Toggle AutoFilter on the current range.
Related Shortcuts
More In This Category
FAQ
How do I use Toggle AutoFilter?
Use it on a table to turn filters on or off without leaving the keyboard.
What shortcuts should I practice after Toggle AutoFilter?
Practice sheet navigation, range selection, and jump-to next and you can move through common Excel work much faster.
Where can I practice Toggle AutoFilter?
Use the page button to start a focused drill right away. If you switch to full practice, you can review sheet navigation, range selection, and jump-to in the same flow.
What is the action preview for Toggle AutoFilter?
A visual pseudo-Excel simulation showing the before and after state when you run the shortcut.