Sorting in Excel allows you to arrange data in a specific order, such as:
- Alphabetical order (A to Z / Z to A)
- Smallest to Largest
- Largest to Smallest
- Oldest to Newest (Dates)
Sorting helps organize data for better analysis and reporting.
Why Sorting is Important
- Makes data easier to read
- Helps find highest or lowest values
- Organizes customer or student lists
- Prepares data for reports
Method 1: Quick Sort (Single Column)
Steps:
- Select any cell in the column
- Go to Data tab
- Click:
- Sort A to Z (Ascending)
- Sort Z to A (Descending)
Example 1: Text Sorting
Names:
Ali
Sara
Ahmed
Bilal
Sort A to Z →
Ahmed
Ali
Bilal
Sara
Example 2: Number Sorting
Marks:
45
90
67
30
Sort Smallest to Largest →
30
45
67
90
Method 2: Custom Sort (Multiple Columns)
Used when sorting a full table.
Steps:
- Select the entire table
- Go to Data → Click Sort
- Choose:
- Column
- Sort On (Values)
- Order (A-Z, Largest to Smallest, etc.)
- Click OK
Example: Sort by Department then by Salary
- First level: Department (A-Z)
- Second level: Salary (Largest to Smallest)
Important Tips
- Always select the full table before sorting
- Make sure headers are checked
- Avoid blank rows in between data
- Use custom sort for multiple levels
Sorting Dates
Excel can sort dates:
- Oldest to Newest
- Newest to Oldest
Common Mistakes
- Sorting only one column (misaligns data)
- Not selecting full table
- Having merged cells
Conclusion
Basic Sorting is a powerful feature that helps organize and analyze data quickly. It improves clarity and makes reporting easier in Excel.