Apply and Remove Filter (Excel Shortcut)

Last Updated: January 10, 2024
puneet-gogia-excel-champs

- Written by Puneet

Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)

To apply a filter on a data column you need to use the keyboard shortcut Ctrl + Shift + L. When you press this keyboard shortcut, Excel applies the date filters to the current columns and as well all the adjoint columns where you have data.

Shortcut to Apply and Remove Filter

Ctrl + Shift + L

Apart from that, there’s one more shortcut key that you can use to apply data filters to the column, and that’s:

Alt > D > F > F.

This keyboard shortcut works the same as the earlier one and you can use the same shortcut key to remove the filter as well.