Excel® 2013 On Demand

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, earliest 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 ...