dropdown menu

if you have got all the names written in some other area, sheet or book
choose all the cells u want to use with lists
then choose
Data -> Validation -> choose list in the first box and fill the third one
with the datarange

""PA via OfficeKB.com"" <forum@OfficeKB.com> wrote in message
news:50EBF401BCE61@OfficeKB.com...
> I have a list of over a thousand names in a dropdown menu. I would like to
> start typing a name in the cell (in the dropdown menu) and have excel
> automatically recognize the name and go to that name in the dropdown menu
> before I even finish typing the full name. How do I do this?
>
> thanks.

thanks for the tip - it worked! Now, how do I have the same combo box in a
100 rows without having to manually copy/paste the box in those rows?

Irene Kral wrote:
>if you have got all the names written in some other area, sheet or book
>choose all the cells u want to use with lists
>then choose
>Data -> Validation -> choose list in the first box and fill the third one
>with the datarange
>
>> I have a list of over a thousand names in a dropdown menu. I would like to
>> start typing a name in the cell (in the dropdown menu) and have excel
>> automatically recognize the name and go to that name in the dropdown menu
>> before I even finish typing the full name. How do I do this?
>>
>> thanks.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200507/1

Select all 100 cells, then apply the DV.

--
HTH

Bob Phillips

"PA via OfficeKB.com" <forum@OfficeKB.com> wrote in message
news:510718C927E00@OfficeKB.com...
> thanks for the tip - it worked! Now, how do I have the same combo box in a
> 100 rows without having to manually copy/paste the box in those rows?
>
> Irene Kral wrote:
> >if you have got all the names written in some other area, sheet or book
> >choose all the cells u want to use with lists
> >then choose
> >Data -> Validation -> choose list in the first box and fill the third one
> >with the datarange
> >
> >> I have a list of over a thousand names in a dropdown menu. I would like
to
> >> start typing a name in the cell (in the dropdown menu) and have excel
> >> automatically recognize the name and go to that name in the dropdown
menu
> >> before I even finish typing the full name. How do I do this?
> >>
> >> thanks.
>
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...excel/200507/1