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

  1. Sort Customer A to Z.
  2. Sort Sales Largest to Smallest.
  3. Sort Product Z to A.