How to sort data in Excel | Microsoft

Sorting is one of the most common tools for data management. In Excel, you can sort your table by one or more columns, by ascending or descending order, or do a custom sort.

Sort the table:

1. Select a cell within the data.
2. Select Home, Sort & Filter. Or, select Data, Sort.
3. Select an option:
• Sort A to Z sorts the selected column in an ascending order.
• Sort Z to A - sorts the selected column in a descending order.
• Custom Sort - sorts data in multiple columns by applying different sort criteria.