How to Create a Drop Down List in Excel Easily

There are a lot of features in excel you can use for processing data, one of them is Data Validation. This feature can be used if you want to validate characters. For example, if you have a field called gender, of course the data should be entered are male and female, not everything else.

drop down list excel

Example of a drop down list in excel.

There is no combo box or drop down list component in excel available. But, if you use data validation and select the data from a list, then the cell will becomes a drop down list automatically. Here’s how to do it.

For example, I have data contain Name and Gender. I create it like a form. Afterwards create source data contain Male and Female on another column.

The first thing you need to do is put the pointer on gender field, then you need to access Data > Data Validation.

data - data validation

Data > Data Validation.

Now select List from allowed data.

allow list

Head to Source, click up arrow and then select the source.

select source

Select it properly. 

selecting list

You can press Enter or click down arrow to finish it.

press enter or down arrow

Click OK. Your drop down list was created.

data validation done

Now you can see a drop down list next to gender field.

create drop down list

You can hide the source column by simply right click the source column and select  hide.

hide source column

Now you can choose data from a drop down list.

drop down list excel

Picking up data from a drop down list.

Share with your friend..