Look Up Another Term

Definition: XL Sort lists


Columns in Excel can be sorted into ascending (A to Z) or descending (Z to A) order. To sort a list, highlight the cells and select Data/Sort. Rows can also be sorted if required.




Sort the States
This example sorts the list of cities into state order. After highlighting the cells and selecting Data/Sort, the dialog asks for the column and sort order.