Skip to main content
A newer version of this page is available. .

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.