how do you add a drop down menu in excel 2016

The source data has been entered using cells A2 and A7 in another worksheet called s ource within the same workbook.Ģ. First, you must set up a list or source somewhere else. This way, you can practice how to add a drop down list in excel at all times.ġ. There is also another option : you can create a dropdown menu in Excel at the time using a range of cell s from the source data for your validation list. Be sure to also learn about how to add a drop down list in excel 2019. T his will create a dropdown list in the selected cells. You have to make sure the dropdown alternative in the cell is checked.ĥ. Where the source field is, enter the options, separated by commas. Where the data validation dialogue box is located, you must select the list as the validation criteria within the configuration tab.Ĥ. Go to the Data tab within the Data Tools Commands group, you must choose the data validation icon. S elect a range or cell of cells where you want to create your dropdown list.Ģ.

If you want to know a simple alternative to how to add a drop down list in excel, then the fastest way is to do it manually.ġ. You must practice each step of how to add a drop down list in excel so that you become a great expert in using this p rogram. If you don't know much about using Excel, don't worry, you can learn with various easy methods like add a drop down list in excel quickly. You can make a drop-down list in Excel in several ways to handle this program perfectly. You need to know to add a drop down list in excel because it is an easy way to control all the values you enter in a cell.

How do you add a drop down menu in excel 2016