58. Sorting data by multiple columns

Sorting Data by Multiple Columns

**Sorting by multiple columns** in Excel allows you to organize data hierarchically. For example, you can sort by department (primary column) and then by employee name (secondary column). This ensures a structured and logical arrangement of your data.

Steps to Sort Data by Multiple Columns

  • Step 1: Select the data range you want to sort.
  • Step 2: Go to the Data tab and click Sort.
  • Step 3: Choose the primary column for sorting (e.g., Department).
  • Step 4: Add a secondary column (e.g., Name) for further sorting.
  • Step 5: Apply the sorting order (ascending or descending) for each column and confirm.

Interactive Example: Sort Data by Multiple Columns

# Department ▲▼ Name ▲▼ Age ▲▼
1 Finance Alice 30
2 Finance Bob 25
3 HR Charlie 28
4 HR Dave 35

Click on column headers (Department, Name, or Age) to sort data by multiple columns. Start with the primary column and refine with others.

Comments