Apply-Remove Filter | Keyboard Shortcut | Microsoft Excel

HomeExcel Keyboard ShortcutsApply-Remove Filter | Keyboard Shortcut | Microsoft Excel

To apply a filter on a data column you need to use the keyboard shortcut Control + 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.

Control + Shift + L

apply-remove-filters-shortcut

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.

➜ Excel Shortcuts Cheat Sheet (PDF)