In order to easily make this list control the values in your pick list do this following. For example, imagine having the following values in cells A1 thru A10: Amarillo These can be either on the same sheet or on another sheet. In a case like this Excel makes it easy to have a list that you keep in a set of cells. Option 1 above is a bit of a hassle if you have a longer list or if the values themselves are longer. In the Source text box, enter the following:Īt this point the cells you had selected will only allow one of the values you specified in the Source field (“Yes”, “No” or “Maybe” in this example).In the Validation criteria section, change the Allow drop-down box from Any Value to List.Select Data Validation from the Data Tools group.Select the cells you want to have the drop down list to pick values from.To create a list with this option do the following. Think of having a list such as “Yes”, “No”, “Maybe” for example. If you want a simple pick list this might be the way to go for you. A 60-second demonstration video is included at the end of this page as well.

The option you pick would depend on the number and length of the items to pick from. I’ll describe a couple of common ways below. You’ve seen drop down pick lists in other people’s spreadsheets and want to do the same in yours. The solution: add a drop down list in Excel.

You need people to stick to the menu of choices to make your analytic life much easier.

You might wind up with “Yes”, “1”, “True”, “Y”, “T”, and who knows what else. You don’t want to have to deal with multiple variations of “yes”, for example. And, you have a column or range of cells that need to have values from a specific set of values. Sometimes you have a sheet that you need other people to fill in. Two ways to add a drop down list in Excel

How to add drop down menu in excel 2016