Create Drop Down List in Excel

Create a Drop-Down List by Using Data Validation Microsoft Excel 2016

You can use Data Validation to create a dropdown list of options in a cell. However, the list font can't be changed, nor can the number of visible rows, which has a maximum of eight. Also, Data Validation doesn't have an AutoComplete feature, which finds matching items in the list as you start to type.

ComboBox Excel ActiveX Control. You can link the Combo Box to a Worksheet cell. Make Excel entry easier with autocomplete and bigger fonts.