Data Validation List

[fireplug30]

I have a set of data in data validation list and I would like to be able to begin typing and the list goes to that part of the list without having to always scroll down to select the data. Any assistance would be appreciated. Its almost like when you start typing in google.

[alansidman]

Go To Tools>Options - Edit And Check Enable AutoComplete For Cell Values
Move Your List Of Items Is In The Range Immediately Above The Validation Cell.
Hide The Rows Above Your Validation Cell.
Now, as you type Excel will look at the list above the Validation cell and AutoComplete based on it.

[purdue7997]

I didn't create this, it was in my arsenal of how to's folder (been there for a number of years as it was originally for 2003). It might be what you are after.

[Tony Valko]

An ActiveX combo box has this capability but its setup is more involved compared to a data validation list.

Also, the drop arrow is always visible.

[purdue7997]

Go To Tools>Options - Edit And Check Enable AutoComplete For Cell Values
Move Your List Of Items Is In The Range Immediately Above The Validation Cell.
Hide The Rows Above Your Validation Cell.
Now, as you type Excel will look at the list above the Validation cell and AutoComplete based on it.

I like this! I'll have to remember it.