You could add a data validation list to the cells in the column. There
are instructions in Excel's help, and he

http://www.contextures.com/xlDataVal01.html

Although data validation doesn't support autocomplete, there's a sample
file here that provides a combobox from which you can select one of the
values from the data validation list. In the combobox, you can enable
autocomplete:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Data Validation Combobox'


Susan wrote:
i want to create a dropdown list in excell that will highlight a word when
first letter is typed


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html