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
Post a Comment