XL Sort lists

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.