Exceljet

Quick, clean, and to the point

Display AutoComplete list

Windows shortcut 
Alt
Mac 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.
In this lesson, we cover shortcuts you can use to to enter data in one or more cells at a time. Knowing these tips can really speed up editing in Excel.
In this video, we'll look at the options available for Excel Tables, including automatic range expansion and a setting to automatically fill formulas.