Select data validation to open the data validation dialog box.

How to create drop down list in excel using data validation. The steps slightly vary depending on whether the source items are in a regular range,. Now, i can either type the name or i can choose the name. I'll click in the source.

Expand on the formula above by using nested if statements. Create a table of itemsor create a list 2. Web to insert a drop down list in excel, you use the data validation feature.

On the first sheet, select cell b1. Our advanced excel training covers: Web so, we select the input cell and click data > data validation.

On the settings tab, under allow , select an option: Web i'll go to the settings tab, i'll hit the drop down by allow, and i'll choose list. Web with data validation, you can create a dropdown list of options in there are 3 easy steps:

In the ribbon, select data >. On the second sheet, create the following named ranges. At the time of this writing, the data validation command icon looks like this: