How to add drop down list using Data validation

Data validations can be used to restrict users to enter invalid data in any cells. Alternatively data validations can also be used to create drop-down list to make GUI where the users can select values from the drop down and reports or graphs can be made available for selected value.

In the screenshot below, the location drop-down is created in cell D2. The graph below is linked with this cell. Whenever dropdown value is changed, graph is updated automatically.

 

Steps to create dropdown list using data validation

Step 1.

Enter the list values in the excel sheet. Make this list in the same sheet in which you require the dropdown list.

Step 2.

Select the cells in which you need the data validation. After that Select DataàData ValidationàData Validation…

Step 3.

1.       Select “List” in Allow dropdown

2.       Select the range in which you have entered the list in source.

3.       Press OK