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 .

1. Open the Excel sheet and select the cells where you want the dropdown list values to be listed

2. In Excel 2010 , select the “Data” tab in the Ribbon and select “Data Validation” combo box and click the Data Validation button .

3. In the Data Validation list , select “list” from the “Allow” combobox .

4. In the Source textbox , Enter Microsoft,Apple,Google each one seperated by a comma and click OK .

5. Now you should see the drop down list appear in the cells that we selected earlier

 

Incoming search terms:

Share