Alternatively, you can simply highlight the block of cells and the cell range above will automatically be put in the Source box.Īt this point, just as in Option 1 above, the cells you had selected will only allow one of the values you specified in the Source field (Some form of yellow in this example).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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |