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.
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.
Now select List from allowed data.
Head to Source, click up arrow and then select the source.
Select it properly.
You can press Enter or click down arrow to finish it.
Click OK. Your drop down list was created.
Now you can see a drop down list next to gender field.
You can hide the source column by simply right click the source column and select hide.
Now you can choose data from a drop down list.