Sort data in a table
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.
Steps to Sort Text
1. Select the column that contains the text you want to sort.
Sort Text
2. On the Home tab, go to the Editing group.
Edit
3. Click Sort & Filter.
Sort and Filter
4. Sort A to Z - Puts text in alphabetical order (A first, Z last). Or sort Z to A - puts text in reverse alphabetical order (Z first, A last).
Sorting in Alphabetical order
Steps to Sort numbers
1. Select a cell in the column you want to sort.
Sorting Numbers
2. On the Home tab, go to the Editing group, then click Sort & Filter.
Sort and Filter
3. To sort from low to high, select 
(Sort Smallest to Largest), or to sort from high to low, select 
(Sort Largest to Smallest).
Smallest to Largest
Steps to Sort Text by a Custom List
1. Select the column that contains the text you want to sort.
Select Text
2. On the Home tab, go to the Editing group.
Editing Group
3. Click Sort & Filter, then choose Custom Sort.
Custom Sort
4. In the Sort dialog box, under Column, select the column you want to sort.
Columns
5. Under Order, choose Custom List.
Custom List
6. In the Custom Lists dialog box, either:
- Select a built-in list (e.g., Monday, Tuesday, …).
- Or type your own list (for example: Large, Medium, Small) and click Add, then click OK.
Custom List Dialog box
7. Click OK again.
Complete Sort