maperalia

In xl2k you can sort your list "ascending" and at each change in the first
letter of your list, insert a cell and place the appropriate letter. In your
dropdown cell first just enter the first letter and then click the dropdown
arrow and you are at the beginning of that part of your list.

Does that help?

Mike Rogers


--
The only dumb question is the one you did not ask.


"maperalia" wrote:

I have created a data validation -list where my source has 3000 names.
The problem is that everytime I dropdrown to see the list I have to scroll
the bar until I find the name I am looking for.

I wonder if there is away to type the first letter and the list will show me
just the names with the first letter instead.

Thanks in advance.
Maperalia