| Windows | Mac |
|---|---|
| Alt↓ | ⌥↓ |
About This Shortcut
This shortcut allows you to display various lists within Excel without using a mouse.
With Alt + down arrow, you can access lists in 3 different contexts:
(1) Access autocomplete items when doing repetitive data entry in a column – previously entered values in cells above will be displayed when autocomplete is enabled.
(2) Access filter drop-down menus when working in a filtered list or table – unique values that appear in a list or column will be displayed with a checkbox to allow filtering.
(3) Access data validation lists when input is restricted by data validation – when a list is used for data validation, the items in that list are displayed.
Related videos
The videos below demonstrate this shortcut.
