Not by using a dropdown list from Data Validation.

Combobox is generally the workaround.


Gord Dibben MS Excel MVP

On Mon, 24 Nov 2008 11:31:41 -0800, Judy
wrote:

Is there a way to program a drop down list in excel to auto fill while
typing? I know it can be done by a combo box, but we would prefer to keep it
as a drop down list and access is not an option at this time. Thank you