The above method is the easiest way to make and edit a drop-down list in Excel. When we click on the “OK,” we may have our drop-down created.In the “Source” section, we must manually enter the values for the drop-down options.In “Settings,” under the “Allow,” select “List.”.Again, click on “Data Validation” in Excel, and a dialog box appears.

Next, click on “Data Validation” in the “Data” tab under the “Data Tools” section.In cell B2, we will enter our drop-down list.There are various ways of editing drop-down lists in Excel. It is done by creating a drop-down lists in excel Drop-down Lists In Excel A drop-down list in excel is a pre-defined list of inputs that allows users to select an option. But if we give users two values to choose from, either male or female, our data would be in the exact order we want. Some people may write answers in uppercase, some in lowercase, or some may make some spelling mistakes. Like in surveys, if there is a question about the gender of a person, if we ask every user to enter values for that question, then data will not be in order. But, if we are creating surveys or asking any other user to enter data and want to give some specific options to choose from, drop-downs in Excel come in handy.Īs explained above, drop-downs in Excel help guide a user to manually enter values in a cell with some specific values to choose from.

Instead, we enter values manually or paste the data from any other source. But in columns, we do not have any drop-downs. In simplified terms, lists in Excel are columns in Excel. Before we edit drop-down lists in Excel, we must know what a list in Excel is.

Drop down menu in excel 2016