Forum Discussion

Copper Contributor

Mar 12, 2023

Solved

Excel AutoComplete not working with Data Validation Lists even after following all fix suggestions

Hi, I would appreciate help with AutoComplete in Excel. Problem: - Data Validation List created does not show suggestions when typing valid entries in the dropdown cell - Clicking on the dropd...

excel

Formulas and Functions

office 365

JKPieterse
Mar 13, 2023
Excel desktop will get those features you are asking for in the near future. Currently, this only works in Excel on-line and on the Insider version of Excel.

BrentM500

Copper Contributor

Apr 05, 2023

Hi JKPieterse

I signed up for the Insider version of Excel (https://insider.office.com/en-us/join/windows) and chose the Beta Channel. Re-initiated Excel and now the Form Control dropdown works like a charm!

Thanks so much for your help..

zorgnum

Brass Contributor

Apr 20, 2023

BrentM500I had the autocomplete function working on my machine and it has suddenly just stopped working. This is sooooooo frustrating, I wish that excel users could be taken seriously with a stable piece of software to work with.