Select cell b3 to make it the active cell.

How to create drop down list in excel using data validation. Web i'll go to the settings tab, i'll hit the drop down by allow, and i'll choose list. In the ribbon, select data >. Web with data validation, you can create a dropdown list of options in there are 3 easy steps:

On the settings tab, under allow , select an option: Our advanced excel training covers: Select data validation to open the data validation dialog box.

Web select data >data validation. Select a cell in which you want the dropdown to appear (d3 in our case). I'll click in the source.

At the time of this writing, the data validation command icon looks like this: On the second sheet, create the following named ranges. Web so, we select the input cell and click data > data validation.

The steps slightly vary depending on whether the source items are in a regular range,. Web to insert a drop down list in excel, you use the data validation feature. Expand on the formula above by using nested if statements.