Improve Data Validation (make it AutoComplete based on typed characters)
Data Validation needs an auto complete in the List Option
It also needs to support Table Structured references directly in the List option without having to wrap it in a Name
Mayur Patel commented
+10 votes for your comment. Google sheet is far better.
I think it is time to shift from MS office to either Google Sheet or WPS. Atleast they care for users.
I've found the solution. Maybe not perfect but for me it is enough. WPS Office has this functionality. I'm testing it now and I'm thinking for my usage it will be enough. And it cost less then MS Office.
Look at screenshot I've attached it exlpain everything.
I have Office 365 fully updated (monthly targeted channel), and believe me there is no such feature available.
Just look at the date of original post, its been 5 years and Excel development team, dont care much about it. God knows why.
Another thing is, even Online version of Excel have lots of bugs, Read comment of @computerclass below which says...
"I cant believe that microsoft hasn't improved this feature in excel. I checked excel online version, it has this feature but to my surprise it only searches the list if first word found in list.
Say if you are searching for "Will Smith",
If you type "will" it will show you the match in dropdown.
If you type "smi" it will NOT show anything from the list.
I mean this is pathetic. Years of development and still we are looking for ease of entering data. This should be there from the very start."
Sad but, This Excel Uservoice page is only for fun, nobody from microsoft reading this ever. Its just a formality to show off that they care what user suggests.
I also have Excel 2019 - No Feature Updates since install last year
@FR8dawg Good points, however, Excel 2019 is a separate product from Office 365 desktop. I have Excel 2019, and it does not get feature updates, only bug patches.
@6StringJazzer (nice handle BTW)
Yes and no. Online versions of applications are constantly being updated. However, they frequently lack features of "full versions". Odd, eh? More complete and less complete at the same time. They also fail to understand the limitations of Internet in many parts of the country. We're not all Redmond or Silicon Washington.
That said, O365 (desktop version) updates quite frequently -- or at least it begs you to update it quite frequently. One would think that any significant improvements found in an online version should show up in the frequently updated desktop version rather soon. Maybe???
@oskar0181 The online version is constantly being updated. The desktop installs are a snapshot in time. Office 2019 is now a pretty old product.
I'm thinking of buy new Office 2019 to this functin. I've checked 7 days trial MS Office 2019 and see what? There is not such basic function :/ In online version this is working like a charm but why there is not this in desktop version.
Do we need to rebuild whole excel to implement this ???? Why the **** there is delay.
5 years since this post, seriously ????
FFS Microsoft - Do you even give a **** about customers anymore
Data Validation - More than 8 items in the Drop Down View & Make it Auto Complete based on typing
How hard can that possibly be?????????????????????????????
Brian Giles commented
Is there any excel community online ? We must post this link there and encourage people to vote for this & lets get it noticed to deaf & blind excel development team
Brian Giles commented
Anybody listening ?
5 years passed & nobody from Excel team cares to reply !!!
What on earth you guys are doing.
Its a real simple feature, dont waste time, just do it.
So as we approach the 5 year anniversary of the original post on this it occurs to me that :
1.) Microsoft could give 2 ***** about what their customers actually need or want and
2.) Microsoft is too big to be concerned with what a measly 226 people think
Here again - how hard can it possibly be to add variable length to and auto complete to it's very old and dated "Drop Down List" in Data Validation?
Tech Reporter commented
Why this feature not implemented till now ? whats the problem ?
Fancy Ribbon commented
Must include this feature in next update. If google can provide such feature since a long time, why microsoft excel development team showing laziness.
Another amazing thing is, this feature request has 220+ votes till now and nobody from excel team care to reply. Wow !
Comeon guys, show some sense.
Please implement this most basic and most awaited feature. Please.
This has been missing for years. It has been requested for years as well. Competitors are offering this solution. It really needs to get some attention.
Plenty of great details in the comments below. Please make it happen.
Hear, hear! Please
If I create a drop down list using Data Validation, I want to be able to search the drop down list by entering some text without having to click anywhere. Simply type few characters and whole list should filter having typed charachters. Google sheets has this feature - Excel should too.