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 .

via How to Create Drop-Down List in Excel ?.

No Responses

Leave a Reply