Lesson 1: Sorting a range on one column

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

Share this

Latest

Most Recent Insights

Most Popular Insights

DOWNLOADABLE RESOURCES

Categories

Related Articles

Is your NGO ready for the changing times?

The issue NGO sustainability is one of the top priorities for most if not all NGO and CBO leaders in Uganda today. So many

Coping in a tough economy

Mustapha met one-on-one with Charles Bwogi of NTV Uganda on the economy. Charles is in bold, below: The Uganda Economy is said to be

The duties of a board chairman

The primary duty of the board Chairman or Chairperson (in gender equality speak) is to manage the board effectively. Individual board members are very

Strategy and the board – who is getting it right?

“Mustapha. Sorry, Mr Strategy, what exactly is the role of the Board in strategy? I have seen many boards just review and approve the

About Author