Drop Down Lists

Hi

I have a drop down list which I would like to make it easier to use. How do
I get the cell which I choose an item from a dropdown list to let me put the
first letter of the word and it automatically jump down to that word?

Thanks

DAWN

Dawn

See Debra Dalgleish's site for instructions on adding a Combo-Box to a Data
Validation list.

The Combo-Box will allow auto-complete, which a DV list alone does not.

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


Gord Dibben MS Excel MVP

On Sun, 2 Apr 2006 13:15:02 -0700, Dawn <Dawn@discussions.microsoft.com> wrote:

>Hi
>
>I have a drop down list which I would like to make it easier to use. How do
>I get the cell which I choose an item from a dropdown list to let me put the
>first letter of the word and it automatically jump down to that word?
>
>Thanks
>
>DAWN

Hi Dawn,

Sort your list and add a single letter at the beginning of each list change,
A at the top of the A list, B at the top of the B list, etc.

Now type in a letter and WITHOUT hitting Enter, click on the drop down
arrow. Should be at the top of that list. (You can hit enter but then you
have to reselect the cell for the arrow to appear)

HTH
Regards,
Howard


"Dawn" <Dawn@discussions.microsoft.com> wrote in message
news:A7BB82F5-D35D-470B-9F4B-51AD0BFD55D1@microsoft.com...
> Hi
>
> I have a drop down list which I would like to make it easier to use. How
> do
> I get the cell which I choose an item from a dropdown list to let me put
> the
> first letter of the word and it automatically jump down to that word?
>
> Thanks
>
> DAWN

Thanks - that's great it works.

"L. Howard Kittle" wrote:

> Hi Dawn,
>
> Sort your list and add a single letter at the beginning of each list change,
> A at the top of the A list, B at the top of the B list, etc.
>
> Now type in a letter and WITHOUT hitting Enter, click on the drop down
> arrow. Should be at the top of that list. (You can hit enter but then you
> have to reselect the cell for the arrow to appear)
>
> HTH
> Regards,
> Howard
>
>
> "Dawn" <Dawn@discussions.microsoft.com> wrote in message
> news:A7BB82F5-D35D-470B-9F4B-51AD0BFD55D1@microsoft.com...
> > Hi
> >
> > I have a drop down list which I would like to make it easier to use. How
> > do
> > I get the cell which I choose an item from a dropdown list to let me put
> > the
> > first letter of the word and it automatically jump down to that word?
> >
> > Thanks
> >
> > DAWN
>
>
>