In the settings, under Allow, click on Lists.Again Click on Data Validation a wizard box appears.Under Data Tab in the data tools section, click on Data Validation.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.
![how to make a drop down list in excel 2010 how to make a drop down list in excel 2010](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2015/05/excel-2010-drop-down-lists-1.jpg)
![how to make a drop down list in excel 2010 how to make a drop down list in excel 2010](https://i.ytimg.com/vi/-qgEmhuXfpw/maxresdefault.jpg)
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.
![how to make a drop down list in excel 2010 how to make a drop down list in excel 2010](https://cdn.ablebits.com/_img-blog/dynamic-dropdown/dynamic-dropdown-source-data.png)
Before we get to editing drop-down lists in excel, we must know the basics of what a list in excel is.