how do you insert a drop down menu in excel 2016

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 do you insert a drop down menu in excel 2016