Excel

How to Make a Drop Down List in Excel

How to Make a Drop Down List in Excel

There are a few ways to make a drop down list in Excel. One way is to create a list of items in one column, and then use data validation to restrict entries to those in the list. Another way is to use a table, and then create a list of items in the table that you want to be available in the drop down list.

To create a drop down list that is restricted to items in a list, follow these steps:

1. Create a list of items in one column.

2. Select the cell or cells that you want to use for the drop down list.

3. On the Ribbon, click the Data tab, and then click Data Validation.

4. In the Data Validation dialog box, click the Settings tab.

5. In the Allow list, select the List option.

6. In the Source list, select the column that contains the list of items.

7. Click OK.

To create a drop down list that is restricted to items in a table, follow these steps:

1. Create a table.

2. Select the cell or cells that you want to use for the drop down list.

3. On the Ribbon, click the Data tab, and then click Data Validation.

4. In the Data Validation dialog box, click the Settings tab.

5. In the Allow list, select the List option.

6. In the Source list, select the table that contains the list of items.

7. Click OK.

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.