How to Create a Drop Down List in Excel ?

An Excel drop-down list is a great way to give the user an option to select from a pre-defined list. It can be used while getting a user to fill a form, or while creating interactive Excel dashboards. It helps in data entry as you can limit the options that can be added to a cell. It also helps in avoiding misspelled words as the user can simply select from the drop down list in Excel. Drop down lists are quite common on websites/apps and are very intuitive for the user. In this tutorial, you'll learn how to create an Excel drop down list (it only takes a few seconds to create one).