Our advanced excel training covers:

How to create drop down list in excel data validation. Explore training > join microsoft 365 insiders > Web on the ribbon, click data > data validation. Select cell b3 to make it the active cell.

Web so, we select the input cell and click data > data validation. On the second sheet, create the following named ranges. Now, i can either type the name or i can choose the name.

In the dialog, set allow to list. Web in the data validation window, under the settings tab, we can type the name of our range into the source field. On the first sheet, select cell b1.

Web i'll go to the settings tab, i'll hit the drop down by allow, and i'll choose list. The steps slightly vary depending on whether the source items are in a regular range,. I'll click in the source.

Select a cell in which you want the dropdown to appear (d3 in our case). Web with data validation, you can create a dropdown list of options in there are 3 easy steps: At the time of this writing, the data validation command icon looks like this:

Web to insert a drop down list in excel, you use the data validation feature. A shortcut to typing the name of our range is f3,. In the source field, enter the formula: