To quickly create searchable or autocomplete drop down list, please do with the following steps:ġ. With the Kutools for Excel’s Searchable Drop-down List feature, you can create a list of searchable drop down list quickly and easily in Excel.Ĭreate searchable or autocomplete drop down list in Excel
In this case, using a searchable or autocomplete drop down list will be a good choice for you, so that when you type the corresponding characters, only the matching items are displayed in the drop down list as below demo shown.
A drop down list can help to fill in a cell quickly without manually typing, but, if there are a long list items, you need to scroll up and down in the list to search the proper item.
0 kommentar(er)
