Lists (Drop down Box)

D

Doug

I have a product list of about 200 items. Is there an easy way to bring up
the items by the first letter of a product.
 
T

T. Valko

Assuming you're using a data validtion list.

The easiest least involved way:

Sort your source list and add the first letters needed:

A
Adam
Allan
Amanda
B
Becky
Ben
Bert
C
Connie
D
Danny
David

Then, in the cell with the drop down type the first letter but *don't* hit
enter, instead, click the drop arrow and the list will "scroll" to the
letter.

There are other methods that are less clunky *but* they're more involved if
you need to use the selection in a formula.
 
D

Dave Peterson

You could apply Data|filter|autofilter (in xl2003 menus) to that column.

Then use a custom filter--begins with X
 
Top