Creating a Drop down list in Excel!

Excel allows users to add any data they want to a cell. Sometimes though you want to constrain this data to a couple of options.

A drop down list in a cell is the easy way to do this!

Lets say you want to create a drop down list for Dept. below – as you can see, people have made small errors typing in dept names (for e.g. sales is lower case and should be Sales)

This image has an empty alt attribute; its file name is 13_Data-Validation.png

To create a drop down list, do the following.

  1. First, make a list of items you want in the drop down. In the picture below, we call this “Values you want in dropdown”.
  2. Then select the cells you want to add a drop down list to.
This image has an empty alt attribute; its file name is 13_Data-Validation_2.png

3. Now go to Data->Data Validation->Data Validation..

This image has an empty alt attribute; its file name is 13_Data-Validation_3.png

4. …and in the dialog that comes up select Validation Criteria to be “List” and Source to be the values you want in the dropdown!

This image has an empty alt attribute; its file name is 13_Data-Validation_4.png

5. Hit “Ok” and click on the cells you selected. You should see dropdowns based on the list values you chose!

This image has an empty alt attribute; its file name is 13_Data-Validation_5.png