Microsoft Office Tutorials and References
In Depth Information
You can sort your Excel data to reorganize the
information. This technique is particularly useful
when using Excel to create database tables. For
example, you might want to sort a client table to
list the names alphabetically. Ascending sorts list
records from A to Z or from lowest number to
highest number; descending sorts list records from
Z to A or from highest number to lowest number.
Perform a Quick Sort
1 Click in the field name, or
heading, that you want to sort.
2 Click the Home tab on the
3 Click the Sort & Filter button.
4 Click an ascending or descending
Excel sorts the records.