Please HELP

[Dmullin1982]

I'm having a moment here..... I am creating a worksheet with multiple drop downs. But I can't get the dropdowns to auto complete. Ie I click the cell and type D and it gives me all options from my list that start with D.... what am I missing or doing wrong?

[#2]

@Dmullin1982 

If you're using Data Validation with the List option: it doesn't provide autocomplete, sadly.

See Data Validation Combo box for a workaround.

[#3]

@Dmullin1982 

In addition, that option is available in Excel Online. For the desktop version the workaround could be https://www.youtube.com/watch?v=NqvB-DqIuP4