Microsoft Excel XP/X
Using the Sort Command
The Sort command will arrange the records (rows) in your database according to the contents of a particular column. Excel will sort the following in ascending order: numbers, text, logical values, error values, and blank cells. A descending sort will reverse the above order, except for blank cells, which are always sorted last.
Once data is sorted, subgroups can be subtotaled. For more information, see Calculating Subtotals in Databases.
-
Select a cell in the column which you would like to sort
-
From the Data menu, select Sort...
The Sort dialog box appears.
-
From the Sort by pull-down list, select the column you want to sort by
NOTE: If column IDs appear instead of column titles, under My list has, select Header row. -
Select the sort order (Ascending or Descending)
- OPTIONAL: If you want to sort by more than one column,
- From the Then by pull-down list(s), select the column you want to sort by
-
Select the sort order (Ascending or Descending)
NOTE: Using the OPTIONS... button allows you to control how to sort lists of days or months, case-sensitive data, and the sort's orientation.
-
When you have the sort criteria established, click OK
The data is sorted.
