excel tutorialSort in Excel
You can sort your Excel data in descending and ascending order. You can sort on one column and sort on several criteria at once. If you only want to sort on one column, execute the following easy steps.
1. Open the accompanied Excel file, and click any cell in the column you want to sort.
2. To sort in ascending order, click on the Data tab and then click AZ.
Result:
Note: in a similar way, you can sort in descending order by clicking on ZA.
Sort on Several Criteria
If you want to sort on several criteria at once, execute the following steps.
1. Click on the Data tab and then click Sort.
The Sort dialog box appears. To sort data by last name first, select Last Name from the first drop-down list. You can leave the other drop-down lists (we sort on values and we sort in ascending order).
Second, we want to sort the records by sales.
2. Click on Add Level and select Sales from the first drop-down list. You can leave the other drop-down lists again.
3. Click on OK.
Result. Records are sorted by last name first and sales second.
Did you like this free Excel tutorial? Show your appreciation, vote for us.