You can show or hide list of formulas while typing in Excel with the help of a shortcut key. Press Alt+Down arrow or make it invisible.

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques.

Range.AutoComplete Method (Excel) Returns an AutoComplete match from the list. If there?s no AutoComplete match or if more than one entry in the list matches the string to complete, this method ...