Explanation
Basic sorting arranges text alphabetically.
- A to Z: Ascending order
- Z to A: Descending order
For numbers:
- Smallest to Largest
- Largest to Smallest
Example
Sort the Customer column A to Z:
|
Customer |
|
Amit |
|
Amit |
|
Neha |
|
Priya |
|
Rahul |
|
Simran |
Sort Sales from Largest to Smallest:
|
Sales |
|
25500 |
|
24000 |
|
10000 |
|
5000 |
|
4000 |
|
4000 |
Important
Always select the complete data range/table, not just one column, when sorting related records.
Practice
- Sort Customer A to Z.
- Sort Sales Largest to Smallest.
- Sort Product Z to A.