Excel

How to Create a Drop-Down List in Excel

How to Create a Drop-Down List in Excel

There are a few ways to create a drop-down list in Excel. The first way is to create a list of items in a column, and then use Data Validation to create the drop-down list. The second way is to use a data validation list in a cell, and then refer to that cell in another cell.

To create a drop-down list in a column, first create a list of items in a column. In the example below, the items in the drop-down list are in the column "Item".

Next, use Data Validation to create the drop-down list. In the example below, the Data Validation is in the column "Choice".

To create a drop-down list in a cell, first create a list of items in a cell. In the example below, the items in the drop-down list are in the cell "A1".

Next, use Data Validation to create the drop-down list. In the example below, the Data Validation is in the cell "B1".

To refer to a data validation list in another cell, use the following formula:

=INDIRECT("A1")

In the example below, the drop-down list in cell "B1" is referring to the list in cell "A1".

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.