Excel

How to Insert a Drop down List in Excel

How to Insert a Drop down List in Excel

There are a few ways to insert a drop down list in Excel. The easiest way is to use a data validation list.

1. Select the cells you want to contain the drop down list.

2. In the Data tab, click Data Validation.

3. In the Settings tab, choose List.

4. In the Source box, type the items you want in the drop down list, separated by commas.

5. Click OK.

You can also create a drop down list by using a table.

1. Create a table with the items you want in the drop down list, in the order you want them.

2. Select the cells you want to contain the drop down list.

3. In the Data tab, click Data Validation.

4. In the Settings tab, choose Table.

5. In the Source box, choose the table you created.

6. 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.