Lesson 1: Sorting a range on one column

Share on facebook
Share on linkedin
Share on twitter
Share on print
Share on email

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

Quiz

Test your Knowledge. Take a Quiz

Subscribe Now to our Newsletter

Subscribe for free news letter and be transformed.