Excel - Sort your data

To quickly sort your data

Select a range of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). The range can include titles that you created to identify columns or rows.
Select a single cell in the column on which you want to sort.
Click to perform an ascending sort (A to Z or smallest number to largest).
Click to perform a descending sort (Z to A or largest number to smallest).

To sort by specific criteria

Select a single cell anywhere in the range that you want to sort.
On the Data tab, in the Sort & Filter group, choose Sort.
The Sort dialog box appears.
In the Sort by list, select the first column on which you want to sort.
In the Sort On list, select either Values, Cell Color, Font Color, or Cell Icon.
In the Order list, select the order that you want to apply to the sort operation — alphabetically or numerically ascending or descending (that is, A to Z or Z to A for text or lower to higher or higher to lower for numbers).