In the cell we want to enter the validation, we will select the cell, i.e., cell B2.In a list or column, copy values for dropdowns or write them down.In this process, we select a range of values and hide the columns so that the other user cannot edit the validation or the dropdown.

Yes, I can use the above process, but it can be changed by the user as he/she can go to the data validation tab and change the values. For the survey, I want to give them just three options: Completed, Pending, Not Started. The above method is the easiest way to make and edit a drop-down list in excel, but if we have to enter more values for the choice of shoes, we have to redo the whole process.Įxample #2 – Giving Drop Down Ranges and Using Data Validation.įor Example, I am a teacher, and I want a response from my students whether they have completed their projects or not.

When we click on the OK, we have our drop-down created.

In the source section, Manually enter the values for the drop-down options.

In Settings under Allow list, select Lists.

Again Click on Data Validation in Excel, and a dialog box appears,.

In Data Tab under the Data Tools section, click on Data Validation.In cell B2, we are going to enter our drop-down list.Now we need to select a cell where we are going to insert the dropdown. Suppose we want to have the values to enter Shoe Brand to choose from. There are various ways of editing drop-downs lists in excel they are:įor the step, we need to have the drop-down values ready to enter. This is done by creating 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 will write answers in uppercase, some in lowercase, or some may make some spelling mistakes. Like in surveys, if there is a question for 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, dropdowns in excel come in handy.Īs explained above, dropdowns in excel help guide a user to manually enter values in a cell with some specific values to choose from. We simply enter values manually in it or paste the data from any other source. But in columns, we do not have any dropdowns. In simplified terms lists in, excels are columns in excel. Before we get to editing drop-down lists in excel, we must know the basics of what a list in excel is.

How to make a drop down list in excel