Microsoft Office Tutorials and References
In Depth Information
Managing Information in Lists
Figure 5-2:
A list in a
worksheet.
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
born.
Book III
Chapter 5
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.
Search JabSto ::




Custom Search