Custom Sorting

Custom Sorting allows you to sort data using multiple levels or your own custom order instead of simple A–Z or Smallest–Largest sorting.

It is useful when:

• Sorting by multiple columns
• Sorting by priority levels
• Sorting months or days in correct order
• Organizing complex reports

How to Apply Custom Sort

Steps:

1. Select the entire table
2. Go to Data tab
3. Click Sort
4. Choose:
   • Column
   • Sort On (Values, Cell Color, Font Color, Icon)
   • Order
5. Click Add Level for multiple sorting
6. Click OK

Example 1: Multi-Level Sorting

Data:

Name	Department	Salary

Requirement:

• First sort by Department (A–Z)
• Then sort by Salary (Largest to Smallest)

Steps:

• Level 1 → Department (A–Z)
• Level 2 → Salary (Largest to Smallest)

This keeps departments grouped and salaries sorted within each department.

Example 2: Custom List Sorting (Months)

By default, alphabetical sorting would arrange:

April
August
December
February

But with Custom Sort, you can sort in proper month order:

January
February
March
April

Steps:

1. Open Sort dialog
2. Choose column
3. Under Order → Select Custom List
4. Choose built-in list (Months or Days)

Example 3: Create Your Own Custom List

If priority levels are:

High
Medium
Low

Create custom order:

1. File → Options → Advanced
2. Edit Custom Lists
3. Add your list
4. Use it in Sort Order

Now Excel sorts:

High
Medium
Low

Sorting by Color

You can sort by:

• Cell Color
• Font Color
• Conditional Formatting Icons

Useful in dashboards and status tracking.

Important Tips

• Always select full table
• Ensure headers are checked
• Avoid blank rows
• Do not merge cells

Why Custom Sorting is Important

• Organizes complex data logically
• Supports professional reporting
• Allows priority-based sorting
• Improves readability

Conclusion

Custom Sorting is a powerful tool for advanced data organization. It gives full control over how your data is arranged and is essential for professional Excel reporting.