Exercise
To sort an Excel list on one column, execute the following steps
- Download the Zip Archive Sorting Data.zip, extract and open the Excel File Sorting Data.xlsx.
- Assuming we want to sort data by the First Name Column, click any cell in that column.
- To sort in ascending order, on the Data tab, click AZ.
Result:
To sort in descending order, click ZA
That’s it for now. Next we shall see how to SORT A RANGE ON MULTIPLE COLUMNS.
Join our next Advanced Excel Training class
