software

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?

HI
BRYCE

TRY
DATA-FILTER-AUTOFILTER

THANKS
quot;brycequot; wrote:

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

actually in the drop down list i want the alphabet to show up versus each
individual record.. that way if i am looking for more than one record that
starts with the same letter....

quot;Abhishek kediaquot; wrote:

gt; HI
gt; BRYCE
gt;
gt; TRY
gt; DATA-FILTER-AUTOFILTER
gt;
gt; THANKS
gt; quot;brycequot; wrote:
gt;
gt; gt; I have a worksheet with over 500 names on it. i want to set up my list in
gt; gt; the drop down menu so that i can search by alphabet versus each individual
gt; gt; record. how can i do this?

Perhaps adding a column and entering the formula =Left(A1,1) and drag that
through. Then use AutoFormat for that. That should give you the first
letter at the very least. its a quick fix at they very least.

quot;brycequot; wrote:

gt; actually in the drop down list i want the alphabet to show up versus each
gt; individual record.. that way if i am looking for more than one record that
gt; starts with the same letter....
gt;
gt; quot;Abhishek kediaquot; wrote:
gt;
gt; gt; HI
gt; gt; BRYCE
gt; gt;
gt; gt; TRY
gt; gt; DATA-FILTER-AUTOFILTER
gt; gt;
gt; gt; THANKS
gt; gt; quot;brycequot; wrote:
gt; gt;
gt; gt; gt; I have a worksheet with over 500 names on it. i want to set up my list in
gt; gt; gt; the drop down menu so that i can search by alphabet versus each individual
gt; gt; gt; record. how can i do this?