Press the data validation shortcut keys alt + a + v + v to bring the following data validation window.

How to create drop down list in excel with example. Select a cell, then select data > data validation. Within the data tools command group, select the data validation icon. Go to the data tab.

In source, type =my list name. Select one or more cells where you want the picklist to appear. Web this example demonstrates the general approach to creating a cascading drop down list in excel by using the new dynamic array functions.

Let's say that the cell. In the dialog, set allow to list. Web this may sound complicated, but it is actually very simple, and a great example of how indirect can be used.

Web on the ribbon, click data > data validation. Web go to the data tab and click on data validation in the data tools group. Web select this range, then click in the name box on the left hand side of the formula bar.

This article explains how to create a drop.