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.

This tip is award winning! Thank you!! - Eileen
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course