Blog Post

Excel Blog
2 MIN READ

Speed up data entry and validation with AutoComplete for dropdown lists in Excel for Windows

Prash_MSFT's avatar
Prash_MSFT
Icon for Microsoft rankMicrosoft
Jan 31, 2022
At Excel, customer focus is at the core of what we do. We appreciate your feedback on adding autocomplete to data validation dropdown lists in Excel for Windows. Your Excel Community votes ensured th...
Updated Sep 02, 2023
Version 2.0
Autocomplete
data validation
Dropdown Lists
proexcelcz's avatar
proexcelcz
Copper Contributor
Apr 20, 2022

"That's only to play on your own and give feedback to Microsoft what you like and what don't."

 

I'm sorry, Sergei, but the development has been going on for several months, and most of us have had the opportunity to try the tool for just a few minutes. No, no, yes, no, no - this is what the availability of the tool in beta looks like. We have been waiting for this tool in Excel for 20 years. Even if we see it officially (maybe in a year, maybe not at all), Ctrl+V will destroy Data Validation? It seems to me that I am not a developer, an Excel user, a lecturer, but a clown. And the same goes for an unavailable calendar in Excel. We obviously don't care about Microsoft. Excel Voice is dead and this is a toy store. Probably not having to deal with user opinions. Should we pay attention to products like OnlyOffice, WPS Office and others? I am sorry for my English.