BAJAN SUN MAGAZINE
NOV 2014
How to alphabetize a list of names in excel.
E
ven if you have a list of names in Word
or another Microsoft program you
might be able to copy and paste them into
excel and then follow these directions to
alphabetize them.
1)
Highlight all the data you want to
alphabetize. Don’t forget all the attached
cells. For example if you have an address list
and only highlight the names and not the
addresses the names will be alphabetized and
the addresses won’t move. Notice DO NOT
highlight the top row (the Header Row). The
computer might recognize it as a Header Row
or it might not.
2)
Next, go to “Data” on the menu bar and
select “Sort” from the list.
3)
In the next window we want to make
sure the computer knows that the top row is a
Header Row and doesn’t need to be
alphabetized with the other rows. If your top
row isn’t a Header Row select “No Header
Row” Then we want to select the column
heading to sort by. In this example we want
to sort by “LastName” in “Ascending” order:
4)
Just click “OK” and your list should be
automatically sorted for you.
Of course you could sort by any heading. For
example if your holiday card list was really
long and you could qualify for bulk rate
postage (more than 500 pieces I believe) you
would want to sort your addresses by Zip
Code for the post office.
You could also use this same process to sort
any list. For example you could sort a list of
students and their SAT scores from highest to
lowest (Descending).
71
www.bajansunonline.com/MAGAZINE/ | [email protected] | @BajanSunOnline