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 first way is to create a list of items in a column, and then select the cell or cells you want the drop down list to appear in. In the Data tab, under Validation, click on Data Validation. In the Settings tab, select List from the Allow drop down list. In the Source tab, select the range of cells that contain the list of items you want in the drop down list.

The second way is to create a table with the items you want in the drop down list. In the Data tab, under Validation, click on Data Validation. In the Settings tab, select Table from the Allow drop down list. In the Source tab, select the table that contains the items you want in the drop down list.

The third way is to create a validation list. In the Data tab, under Validation, click on Data Validation. In the Settings tab, select List from the Allow drop down list. In the Source tab, type the items you want in the drop down list, one item per line.

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.