Share via

EXCEL: Data Validation Dropdown Search is not working

Anonymous
2023-04-27T10:21:02+00:00

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.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

5 answers

Sort by: Most helpful
  1. Anonymous
    2023-09-18T15:56:01+00:00

    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

    Image

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2023-04-27T11:55:01+00:00

    Sure. Appreciate your kind support on this.

    Thank you 😊😊😊

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2023-04-27T11:45:36+00:00

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

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2023-04-27T11:37:09+00:00

    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

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2023-04-27T11:07:28+00:00

    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.

    Was this answer helpful?

    0 comments No comments