Right click it and then select Properties from the right-clicking menu.ĥ. Click Developer > Insert > Combo Box (ActiveX Control).Ĥ. In this Excel Options window, click Customize Ribbon in the left pane, check the Developer box, and then click the OK button.

Otherwise, do as follows: Click File > Options to open the Options window. If the Developer tab is showing on your ribbon, shift to step 3. Before inserting a Combo box, you need to add the Developer tab to the Excel ribbon. Open the worksheet that contains the drop down list cell you want to make it autocomplete.Ģ. Firstly, you need to insert a combo box into the worksheet and change its properties.ġ. Please do as follows to make a drop down list autocomplete after typing corresponding letters in the cell. This tutorial provides two methods to help you achieve it.Īutocomplete when typing in drop down list with VBA codeĪutocomplete when typing in drop down list with an amazing tool Are there any methods to make an auto-completed drop-down list when typing the first letter or any relative characters? That will help people work more efficiently in worksheets with drop-down lists in cells. How to autocomplete when typing in Excel drop down list?įor a data validation drop-down list with lots of items, you need to scroll up and down in the list to find the one you need or type the whole word into the list box correctly.

Create a drop down list in excel