If you created the dropdown list through Data Validation, it doesn't
support autocomplete (if that's what you mean by autofill).
If you can use programming, there are instructions here for adding 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/xlDataVal11.html
