Searchable Dropdowns in Excel RRS feed

  • Question

  • In excel few of my columns have dropdowns whose lists are populated from backend database. As the dropdown list may have many values, it would be nice to have a autocomplete search functionality at the cell level containing the dropdown, rather than scrolling the entire list.

    I have checked for some solutions on the net, but it seems Excel does not have this feature, and we may have to use some third party plug-ins to achieve the same.

    Is there any way to achieve this functionality without installing add-ins?.

    Thanks In Advance!!!..

    Wednesday, February 21, 2018 2:08 PM


All replies