excel drop down list

TONY · External Since: Oct 05, 2009 Posts: 2

How can I get auto text to work on a drop down list?

Instead of having to scroll down I want to enter the first letter and it
will take to me the section I wish to use

JP · External Since: Mar 13, 2009 Posts: 14

The dropdown list (I assume Data Validation) has to be adjacent to the
entries you want for the autotext. For example, if you have some
entries in A1:A10, the autotext would work for A11 and below. If there
are blanks in the column, the auto text won't pick it up.

--JP

On Oct 5, 11:10 am, TONY <T... RemoveThis @discussions.microsoft.com> wrote:
> How can I get auto text to work on a drop down list?
>
> Instead of having to scroll down I want to enter the first letter and it
> will take to me the section I wish to use

TONY · External Since: Oct 05, 2009 Posts: 2

It is in the drop down list itself

Its along list so in order to find someone quickly I just want to enter
the first letter and the list will go to that letter

"JP" wrote:

> The dropdown list (I assume Data Validation) has to be adjacent to the
> entries you want for the autotext. For example, if you have some
> entries in A1:A10, the autotext would work for A11 and below. If there
> are blanks in the column, the auto text won't pick it up.
>
> --JP
>
>
> On Oct 5, 11:10 am, TONY <T....RemoveThis@discussions.microsoft.com> wrote:
> > How can I get auto text to work on a drop down list?
> >
> > Instead of having to scroll down I want to enter the first letter and it
> > will take to me the section I wish to use
>
>

JP · External Since: Mar 13, 2009 Posts: 14

Data Validation won't work quite like that. It will auto-fill the
text, but it won't drop down the list and show you the entries. You
would use a combo box for that. But a combo box won't auto-fill, it
will just jump to the first matching entry.

So if you want auto-fill, use Data Validation. If you want to drop
down the list, use a combo box.

--JP

On Oct 5, 11:24 am, TONY <T....TakeThisOut@discussions.microsoft.com> wrote:
> It is in the drop down list itself
>
> Its along list so in order to find someone quickly I just want to enter
> the first letter and the list will go to that letter
>
>
>
> "JP" wrote:
> > The dropdown list (I assume Data Validation) has to be adjacent to the
> > entries you want for the autotext. For example, if you have some
> > entries in A1:A10, the autotext would work for A11 and below. If there
> > are blanks in the column, the auto text won't pick it up.
>
> > --JP
>
> > On Oct 5, 11:10 am, TONY <T....TakeThisOut@discussions.microsoft.com> wrote:
> > > How can I get auto text to work on a drop down list?
>
> > > Instead of having to scroll down I want to enter the first letter and it
> > > will take to me the section I wish to use- Hide quoted text -
>
> - Show quoted text -

L. Howard Kittle · External Since: Jan 12, 2005 Posts: 331

Sort your validation list and at the beginning of the A's enter a single A,
do the same for the beginning of the B's and all the way through to the Z's.

Click in the cell that has the drop down validation and type in the letter
of the list you desire... say you type in an O. DO NOT hit enter... leave
the cell in the edit mode (still selected) and now hit your down arrow.

Should take you to the O which is the top of the O list of selections.

HTH
Regards,
Howard

"TONY" <TONY RemoveThis @discussions.microsoft.com> wrote in message
news:F232985D-985C-46EC-A4F3-ED912A052916@microsoft.com...
> How can I get auto text to work on a drop down list?
>
> Instead of having to scroll down I want to enter the first letter and it
> will take to me the section I wish to use