EXCEL: Data Validation Dropdown Search is not working

Question

I have various excel data validations that I have applied on my entire excel sheets & workbooks. And I am using these for a long time. Before it was working all good. I used to type something in a cell and I could see the dropdown options based on my typed keywords. But now I am unable to see any dropdown, after typing any keywords in the same cell. This is really annoying and now it takes longer time to prepare my data.

I have tried all possible solutions on my excel settings. But I could not find anything as the same settings are applied on my other PC and they are working well.

EDIT: I tried to open the same file in my excel in other PC but in other PC its working perfectly fine.

Thanks.

Answer 1

Searchable dropdown is now available in current and monthly channel.

Data Validation dropdown list autocomplete: Dropdown lists are a handy way to make data entry and validation more efficient in Excel. We’ve now added AutoComplete functionality, which automatically compares the text typed in a cell to all items in the dropdown list and displays only the items that match. You’ll spend less time scrolling through lists, dealing with data validation errors, or writing complex code to handle this task.
See details in blog post

Update history for Microsoft 365 Apps (listed by date) - Office release notes | Microsoft Learn

Answer 2

Sure. Appreciate your kind support on this.

Thank you 😊😊😊

Answer 3

I hope so. I will notice you when the feature is released officially.

Answer 4

Thanks for your valuable reply.

Yes you're right, I have my personal subscription (Family Subscription) as well and from that I have subscribed to Insider Preview. Perhaps this feature is still working because of this. But for business subscription this feature is no more working.

Anyways, I hope to get this feature soon as it really helps a lot to manage the data in time.

Kind Regards,

Arslan

Answer 5

Recently, several users received this feature and suddenly disappeared. It could be Microsoft is testing this feature and the feature maybe released in the near future.

AutoComplete for DropDown is only for Insider user.

Speed up data entry and validation with AutoComplete for dropdown lists in Excel for Windows (office.com)

I haven't seen the feature is released.

Update history for Microsoft 365 Apps (listed by date) - Office release notes | Microsoft Learn

You can raise support ticket to get more information about the feature when it will be released.

Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request.