Technology Tip Number 164
Sorting Through the List

Have you ever wanted to sort a list of data into different categories.  For example, sort a grocery list by the location of each item in the store, or a budget by largest to smallest expenses, or a list of students alphabetically.  This Technology Tip will help you sort lists of information in Excel: 

1)     Open the excel file you wish to sort. 

2)     Highlight all of the data you want to sort

3)     Select “Data” and then “Sort” from the menu bar:

4)     Choose what you’d like to sort by, then click “OK”.  For example, you could sort the list by “HR” to see what "home room" the students on this list are in.  Or, you could sort the list in ascending or descending alphabetical order by last names.

PRACTICE ACTIVITY:  Try sorting a list in excel today.

TO KEEP ON LEARNING:  To learn more about sorting lists in Excel try searching the internet for:

Sorting in excel
Ascending and descending order in excel
Sorting Lists

Looking for Something?