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 create a drop down list in Excel. The easiest way is to use a data validation list.

To create a data validation list, select the cells that you want to use for the list and then go to the Data tab and select Data Validation. In the Data Validation window, select List and then enter the items that you want in the list.

You can also create a drop down list by using a formula. To do this, you'll need to create a list of items in a separate column and then use the INDEX function to create the drop down list.

Finally, you can also create a drop down list by using a macro. To do this, you'll need to create a list of items in a separate column and then use the VBA code to create the drop down list.

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.