Calc - Searchable Drop-down list without using mouse

[daveb3030]

I am going for a way to make a drop-down list display only the matches that correspond to the text that I enter into a cell, and for it to update the more characters that I type. I have a named range that I want to search through. I have tried both of the following but neither is want I am looking for. In my target cells I have selected
1.) Data - Validity - Allow List - pasted the list into the Entries Box
2.) Data - Cell Range - Source - type in the Managed Name

Both of these approaches require me to click on the down arrow to select the appropriate data.
I do not want to have to use the mouse to select the correct data. Ideally I would like to type a few characters and either hit enter if it matches, or use the down arrow to select the correct data and then hit enter.

Any help would be greatly appreciated.
Dave

[Wanderer]

@daveb3030

1.) Data - Validity - Allow List -

Try Alt-Down key to open the List via keyboard.

[daveb3030]

Thanks Wanderer, I was not aware of that keyboard shortcut. This is certainly far better than using the mouse to select the data. I would still like to be able to just typing in the cell and see the list dynamically narrow to fit the typed data. But if that is not possible I will use this as an alternate solution.
Thanks