Windows Mac
Alt↓ ⌥↓

About This Shortcut 

Use this shortcut to activate a filter that already exists. Excel will then display sorting and filtering options. You must be in the cell that contains the filter (the dropdown arrow) before you use the shortcut.

Related videos

Excel Shortcuts for Excel Tables

Shortcuts for Excel Tables

In this video, we’ll look at shortcuts you can use in an Excel Table. Excel Tables are one of Excel’s most powerful features for working with data. To create a table, just select a cell in the data and use Control + T. New tables have filters enabled. To toggle filters, use Ctrl-Shift-L in Windows, …
Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.