Drop Down Lists – Select Custom Inputs

Suppose you have to add drop down list for the Type field in the following worksheet.

Open Data Validation window [See data validation tutorial]. Select List from Allow drop down list and click on the right button of Source text box.
Type comma separated list items that you want to add in the drop down list. Press enter and click on OK button.
Now a drop down button is attached with Type field and if the user click on the button then the list will open to select any item.
In this way, you can easily add drop down list feature in the cell of any excel sheet and restrict user from entering other data.

Was this article helpful?

Related Articles

Leave a Reply