15 hours of free training in just 5 minutes a day
Technology Tip Number 47
A to Z in Excel
Today’s Technology Tip is a practical use for Excel that any teacher could appreciate: How to alphabetize a list of names in excel.
Even 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.
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. In the
example below I have correctly highlighted the data on my Gilligan’s
Island address list:
Next, go to “Data” on the menu bar
and select “Sort” from the list:
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”
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).
Featured YouTube Video
PRACTICE ACTIVITY: Open up a blank excel document, create a short list of names and try sorting them alphabetically using the above procedure.
TO KEEP ON LEARNING: If you're feeling the need to learn more about Microsoft Excel try searching the internet for:
Have a nice day!
180 Technology Tips
Copyright © 2006- 180TechTips.com