Microsoft Office Tutorials and References
In Depth Information
Sorting Data in a Table
Sorting Data in a Table
After you enter records in a list, you can reorganize the information by sorting the records.
For example, you might want to sort records in a client list alphabetically by last name or
numerically by their last invoice date. Ascending order lists records from A to Z, earli-
est to latest, or lowest to highest. Descending order lists records from Z to A, latest to
earliest, or highest to lowest. You can sort the entire list or use AutoFilter to select the
part of the list you want to display in the column. You can also sort a list based on one
or more sort fields —fields you select to sort the list. A sort, for example, might be the
telephone directory numerically by area code and then alphabetically by last name. If you
have manually or conditionally formatted a range or table column by cell or font color or
by an icon set, you can sort by these cell attributes using the Sort button.
Sort Data Quickly
Click the table cell with the field name by which you want to sort.
• You can also click a column header list arrow, and then click Sort A to Z or
Sort Z to A .
Click the Data tab.
Click the Sort Ascending or the Sort Descending button.
Search JabSto ::

Custom Search