Sorting Data (Single and Multi-Level)0%

Sorting Data (Single and Multi-Level)

Beginner12 min read•Updated: Jul 11, 2026

Sorting Data (Single and Multi-Level)

Sorting rearranges your records to uncover patterns, prioritize tasks, and prepare information for reporting. Excel allows both simple single-column sorting and sophisticated multi-level hierarchical sorting with custom sorting orders.

1. Single-Column Sorting (A-Z and Z-A)

Single-column sorting rearranges all rows in a dataset according to the values in one selected column:

Ascending (A to Z / Smallest to Largest / Oldest to Newest): Sorts alphabetically from A to Z, numbers from lowest to highest, or dates from earliest to latest.
Descending (Z to A / Largest to Smallest / Newest to Oldest): Inverts the order to display the highest revenue, newest transactions, or reverse alphabetical names at the top.

1Quick Sort Commands:
2- Data Tab > Sort A to Z or Sort Z to A
3- Right-click any cell > Sort > Sort A to Z

Important Warning

Warning: The "Expand the Selection" Dialog: If you select only a single column within a multi-column table before sorting, Excel warns you: "Excel found data next to your selection." Always choose Expand the selection! If you choose "Continue with the current selection", only that single column will reorder, irreparably scrambling employee names from their salaries and addresses!

2. Multi-Level Hierarchical Sorting

In real-world business datasets, multiple rows share identical values (e.g., several employees in the 'Sales' department). Multi-level sorting allows you to establish tie-breaker criteria:

Setting Up Multi-Level Sorting:

1
Click any single cell inside your dataset.
2
Go to the Data tab and click the large Sort button (or press Alt + A + S).
3
In the Sort dialog box:

Ensure My data has headers is checked.
Level 1 (Primary): Sort by Department | Sort On: Cell Values | Order: A to Z.
Click Add Level.
Level 2 (Secondary): Then by Branch | Sort On: Cell Values | Order: A to Z.
Click Add Level.
Level 3 (Tertiary): Then by Sales Amount | Sort On: Cell Values | Order: Largest to Smallest.

1
Click OK.

Result: All rows are grouped first by Department. Within each Department, rows are organized alphabetically by Branch. Within each Branch, high-performing sales figures appear at the top.

3. Custom List Sorting (Non-Alphabetical Orders)

Certain categories possess natural logical sequences that are not alphabetical (e.g., T-Shirt Sizes: Small, Medium, Large, XL; or Priority: High, Medium, Low):

1
In the Sort dialog box, under the Order dropdown, choose Custom List....
2
Select an existing custom list (e.g., 'Jan, Feb, Mar...' or 'Sun, Mon, Tue...'), or create a NEW LIST.
3
Under List entries, type:

 High
 Medium
 Low

1
Click Add, then click OK.
2
Your dataset now sorts strictly according to organizational priority rather than alphabetical 'H-L-M'.

Interactive Quiz• Knowledge Check

Multiple Choice Questions

Question 1

What critical danger occurs if you select only one column in a table and sort with 'Continue with the current selection'?

Question 2

How can you sort a project task table so that tasks are ordered first by 'Status' (High, Medium, Low) and then by 'Due Date' (Oldest to Newest)?

Question 3

Which option in the Sort dialog box ensures that row 1 containing column titles is not sorted into the data body?

Question 4

What feature allows you to sort values in the order 'Jan, Feb, Mar, Apr' instead of alphabetical 'Apr, Feb, Jan, Mar'?

Question 5

Can Excel sort rows based on cell background color or font color rather than cell values?

Next Lesson

Filtering Data with AutoFilter

Continue learning with hands-on practice, examples, and exercises in the upcoming topic.

Related Lessons

Previous Lesson	Next Lesson
Using AutoFill and Flash Fill Efficiently	Filtering Data with AutoFilter

Practice Quiz

Test your understanding of this lesson with 5 questions. Each question has one correct answer.

Previous Next

PreviousPrevNext

MSK Institute • Shikohabad

Loading Page Content...

Preparing courses, live labs, and learning resources.सामग्री लोड हो रही है, कृपया प्रतीक्षा करें...

Connecting serverPlease wait...

💻 Practical Labs🚀 Free Demo📜 Verified Certificates

Filtering Data with AutoFilter

Sorting Data (Single and Multi-Level)

Beginner12 min read•Updated: Jul 11, 2026

Study Materials Cheatsheet

Sorting Data (Single and Multi-Level)

1. Single-Column Sorting (A-Z and Z-A)

Single-column sorting rearranges all rows in a dataset according to the values in one selected column:

Ascending (A to Z / Smallest to Largest / Oldest to Newest): Sorts alphabetically from A to Z, numbers from lowest to highest, or dates from earliest to latest.
Descending (Z to A / Largest to Smallest / Newest to Oldest): Inverts the order to display the highest revenue, newest transactions, or reverse alphabetical names at the top.

1Quick Sort Commands:
2- Data Tab > Sort A to Z or Sort Z to A
3- Right-click any cell > Sort > Sort A to Z

Important Warning

2. Multi-Level Hierarchical Sorting

In real-world business datasets, multiple rows share identical values (e.g., several employees in the 'Sales' department). Multi-level sorting allows you to establish tie-breaker criteria:

Setting Up Multi-Level Sorting:

1
Click any single cell inside your dataset.
2
Go to the Data tab and click the large Sort button (or press Alt + A + S).
3
In the Sort dialog box:

Ensure My data has headers is checked.
Level 1 (Primary): Sort by Department | Sort On: Cell Values | Order: A to Z.
Click Add Level.
Level 2 (Secondary): Then by Branch | Sort On: Cell Values | Order: A to Z.
Click Add Level.
Level 3 (Tertiary): Then by Sales Amount | Sort On: Cell Values | Order: Largest to Smallest.

1
Click OK.

Result: All rows are grouped first by Department. Within each Department, rows are organized alphabetically by Branch. Within each Branch, high-performing sales figures appear at the top.

3. Custom List Sorting (Non-Alphabetical Orders)

Certain categories possess natural logical sequences that are not alphabetical (e.g., T-Shirt Sizes: Small, Medium, Large, XL; or Priority: High, Medium, Low):

1
In the Sort dialog box, under the Order dropdown, choose Custom List....
2
Select an existing custom list (e.g., 'Jan, Feb, Mar...' or 'Sun, Mon, Tue...'), or create a NEW LIST.
3
Under List entries, type:

 High
 Medium
 Low

1
Click Add, then click OK.
2
Your dataset now sorts strictly according to organizational priority rather than alphabetical 'H-L-M'.

Interactive Quiz• Knowledge Check

Multiple Choice Questions

Question 1

What critical danger occurs if you select only one column in a table and sort with 'Continue with the current selection'?

Question 2

How can you sort a project task table so that tasks are ordered first by 'Status' (High, Medium, Low) and then by 'Due Date' (Oldest to Newest)?

Question 3

Which option in the Sort dialog box ensures that row 1 containing column titles is not sorted into the data body?

Question 4

What feature allows you to sort values in the order 'Jan, Feb, Mar, Apr' instead of alphabetical 'Apr, Feb, Jan, Mar'?

Question 5

Can Excel sort rows based on cell background color or font color rather than cell values?

Next Lesson

Filtering Data with AutoFilter

Continue learning with hands-on practice, examples, and exercises in the upcoming topic.

Related Lessons

Previous Lesson	Next Lesson
Using AutoFill and Flash Fill Efficiently	Filtering Data with AutoFilter

Practice Quiz

Test your understanding of this lesson with 5 questions. Each question has one correct answer.

Previous Next