How to Create Drop-Down List in Excel ?
Creating a lookup or dropdown list in Excel is very simple and easy too . The drop down list provides an option to lookup to an existing values and avoids the users from enter the values manually each and every time again and again . To do this , we must add the list of values to the data validation list
In this example , i provide the values in the source teextbox directly instead of using the cells for the values .