Excel data validation is not showing the list when I start typing i have to click the down arrow. It will work on both of my other computers.

Question

this is a simplified example

Answer 1

Which version of Office/Excel is installed on the computer that does not display the drop-down list automatically?

Answer 2

Is this the version you want?

Answer 3

Thanks. You're on the Semi-Annual Enterprise Channel. This channel introduces new features with a delay, and only twice a year, on the second Tuesday of January and July. So you should get an update this coming Tuesday, the 9th of July. I expect that autocomplete for data validation will be included in this update.

Answer 4

Thank you so much I spent way to long trying to figure this out before I wrote my question.