How To Apply Filter In Excel Shortcut?

Select any cell in your data range

Press Ctrl + Shift + L to apply or remove filters

Or press Alt + D + F + F to toggle AutoFilter

If using a Mac, press Command + Shift + F

To open filter dropdowns, use Alt + Down Arrow on Windows

To clear a filter, open the dropdown and choose Clear Filter From

To reapply filters after changes, press Ctrl + Alt + L

Suggested for You

Trending Today