Then, go to the data tab and click “data validation” in the data tools section of the ribbon.

How to create drop down list in excel data entry form. Web select the cell where you want the list. Web add a list box to your excel worksheet from which users can choose a value. Add the form tool to excel;

Web excel data entry form; Web select a cell in which you want the dropdown to appear (d3 in our case). In the data validation dialog.

Web the data validation dialog box displays. This is useful when you. I have a whole playlist of excel.

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