Microsoft Office Tutorials and References
In Depth Information
Managing Information in Lists
A list in a
Sorting a list
Sorting means to rearrange the rows in a list on the basis of data in one or
more columns. Sort a list on the Last Name column, for example, to arrange
the list in alphabetical order by last name. Sort a list on the ZIP Code column
to arrange the rows in numerical order by ZIP Code. Sort a list on the
Birthday column to arrange it chronologically from earliest born to latest
Starting on the Data tab, here are all the ways to sort a list:
✦ Sorting on a single column: Click any cell in the column you want to use
as the basis for the sort; then click the Sort Smallest to Largest or Sort
Largest to Smallest button. (On the Home tab, you can get to these
buttons by clicking the Sort & Filter button first.) For example, to sort item
numbers from smallest to largest, click in the Item Number column and
then click the Sort Smallest to Largest button.
✦ Sort on more than one column: Click the Sort button on the Data tab.
You see the Sort dialog box, as shown in Figure 5-3. Choose which
columns you want to sort with and the order in which you want to sort. To
add a second or third column for sorting, click the Add Level button.