Excel

How to Add a Drop down List in Excel

How to Add a Drop down List in Excel

To add a drop down list in Excel, you first need to create a list of items that you want to appear in the drop down. This can be done in a separate worksheet, or in the same worksheet where you want to use the drop down.

Next, select the cells where you want the drop down to appear. In the ribbon, go to the Data tab and click on the Validation button. In the Validation dialog box, select the List option.

In the Source box, enter the range of cells that contains the list of items you want to appear in the drop down. Click the OK button.

Now when you click in one of the cells in the range that you specified, a drop down list will appear, containing the items from the 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.