On the data tab, in the data tools group, click data validation.

How to create drop down list in excel data entry form. Make data entry easier by letting users choose a value from a combo box. Web add a list box to your excel worksheet from which users can choose a value. Web select the cell where you want the list.

Make sure the items are consecutive (no blank rows). Then, go to the data tab and click “data validation” in the data tools section of the ribbon. Web select a cell in which you want the dropdown to appear (d3 in our case).

This is useful when you. Web excel data entry form; Web the data validation dialog box displays.

I have a whole playlist of excel.