Toggle Autofilter in Excel (Ctrl + Shift + L)
The Toggle Autofilter shortcut quickly turns on or off the filter buttons on your table or data range. This helps in sorting and filtering data without navigating through the Ribbon.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Shift + L | Cmd + Shift + F |
What Does This Shortcut Do?
Pressing this shortcut will either apply filter dropdowns to your selected data or remove existing filters if already applied.
How to Use the Shortcut
- Select the range or table where you want to apply the filter
- Press Ctrl + Shift + L (Windows) or Cmd + Shift + F (Mac)
- Filter dropdowns appear in the header row or disappear if already active
- Click the dropdowns to sort or filter your data
Tips & Best Practices
- Always select the header row to properly enable filters
- Toggle off when filters are no longer needed to prevent confusion
- Combine with keyboard navigation for faster filtering
FAQ
- Q: Does it work on tables created with Ctrl + T?
- Yes, tables automatically have filters, but this shortcut can toggle them off if needed.
- Q: Can I filter non-table ranges?
- Yes, it works on any selected range with a header row.