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
Excel user voice is ********, nobody listening.
Sergio Cristovao commented
I don´t understand the reason that this company open a channel to listen their users, and simply ignore them. Some small changes, it seems that it hurts the ego, or competence, to death, or it seems that it tries to hide something that was done badly. I really don't know why they don't serve their users. This request was 5 years old.
Microsoft became deaf & blind.
MS obviously doesn't really Give A Sh#t - Right now they are way too busy implementing the Global Economy
Excel Helper commented
Excel guys are deaf and blind about this basic and fundamental feature. hehe
Its high time to implement this feature. Excel development team should feel shame about this. Users are doing all kind of workarounds to achieve this simple and fundamental basic feature. What on earth stopping you guys to do this. 5 Year old thread and 250+ votes, I wonder if excel team ever visited this page haha. Shameful.
Any chance to update Excel to behavior like oskar0181 show below on screen. Autocomplete cells is the fundamental function. Why MS do not listening their customers.
Monika Rybnicka commented
MS should copy this functionality direct from WPS Office - like user oskar 0181 shown below in comments. I've tested it and this is amazing feature. MS Excel is very stable, fast and good software and I can not understand why there is no such simple function.
PS : and allow more than 8 items in the drop down box (OMG this is way past due)
Kevin Osborn commented
Microsoft ... time to take this one to a vote. It's buried being 5 years old but it's a serious issue. No reason in 2020 that the user cannot start typing and have the data validation list open and go to the first combination of the characters entered.
ps. And allow Tab to select the item and move to the the next cell. Don't force the user to only select the item using the Enter key.
Looks like Microsoft has only 2-3 guys in the name of so called excel development team. They do what they like.
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.