HI
BRYCE

TRY
DATA-FILTER-AUTOFILTER

THANKS
"bryce" wrote:

I have a worksheet with over 500 names on it. i want to set up my list in
the drop down menu so that i can search by alphabet versus each individual
record. how can i do this?