Is there a way to quickly seek data in a drop down list? I have a
spreadsheet with a significant amount of data in a drop down list and I'd
like to be able to access "Table" by typing "T" or "Chair" by typing "C". Is
this possible?

Depends on whether you are using a combobox from the toolbox or data
validation. From the tool box use the built in MatchEntry in the properties.
Validation does not support this.
-John

"OCS_IT" wrote:

Is there a way to quickly seek data in a drop down list? I have a
spreadsheet with a significant amount of data in a drop down list and I'd
like to be able to access "Table" by typing "T" or "Chair" by typing "C". Is
this possible?

I was using Validation and had a feeling the answer was going to be "can't be
done". I'll have to do some research to understand Macros and try the
combobox.

Thanks...

"John Bundy" wrote:

Depends on whether you are using a combobox from the toolbox or data
validation. From the tool box use the built in MatchEntry in the properties.
Validation does not support this.
-John

"OCS_IT" wrote:

Is there a way to quickly seek data in a drop down list? I have a
spreadsheet with a significant amount of data in a drop down list and I'd
like to be able to access "Table" by typing "T" or "Chair" by typing "C". Is
this possible?

Hi

You can't have autocomplete, but there is a small workaround.
Enter some "dummy" single letter entries in your list, A, B, C etc. and
sort the list.
In the DV cell, enter T then press the dropdown, and you will be at the
beginning of your T entries - saves a lot of scrolling.

--
Regards

Roger Govier


"OCS_IT" wrote in message
...
I was using Validation and had a feeling the answer was going to be
"can't be
done". I'll have to do some research to understand Macros and try the
combobox.

Thanks...

"John Bundy" wrote:

Depends on whether you are using a combobox from the toolbox or data
validation. From the tool box use the built in MatchEntry in the
properties.
Validation does not support this.
-John

"OCS_IT" wrote:

Is there a way to quickly seek data in a drop down list? I have a
spreadsheet with a significant amount of data in a drop down list
and I'd
like to be able to access "Table" by typing "T" or "Chair" by
typing "C". Is
this possible?

If your drop-down list is from Data Validation, you cannot have Autocomplete.

Try a combo-box drop-down list.

Debra Dalgleish has instructions.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

On Wed, 6 Dec 2006 12:35:01 -0800, OCS_IT
wrote:

Is there a way to quickly seek data in a drop down list? I have a
spreadsheet with a significant amount of data in a drop down list and I'd
like to be able to access "Table" by typing "T" or "Chair" by typing "C". Is
this possible?

Gord Dibben MS Excel MVP