How to sort in Excel
Excel allows you to organize your data by sorting it based on one or multiple columns. Sort your data by one or more columns, either A to Z or Z to A.
Sorting by a Single Column
To arrange your data based on a single column, follow these steps:
1. Select any cell within the column you want to sort.
2. Navigate to the Data tab, and in the Sort & Filter group, click on A-Z to sort in ascending order.
Result:
Note: To sort in descending order, click on Z-A instead.
Sorting by Multiple Columns
To sort data using multiple columns, follow these instruction:
1. Go to the Data tab and click Sort in the Sort & Filter group.
This will open the Sort dialog box.
2. From the Sort by dropdown list, select Last Name as the primary sorting column.
3. Click on Add Level to introduce another sorting criterion.
4. From the Then by dropdown list, select Sales as the secondary sorting column.
5. Click OK to apply the sorting.
Result
Now, the data will first be arranged by Last Name, followed by Sales.
✅ 1/8 Completed! Ready to learn more about sorting? ➝
Next Chapter: Filtering Data