Sort and Filter

The key combinations that allow you to activate the filtering functionality for a worksheet range or table are listed in the table below.

Shortcut Description
CTRL+SHIFT+L Toggles between enabling and disabling the AutoFilter functionality.
CTRL+ALT+L Reapplies a filter.