Display AutoComplete list

Display AutoComplete list
Windows shortcut 

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.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas