This lesson follows on from yesterday’s “Sorting a range on one column“. Please download and extract the sample file here.

To sort on multiple columns, execute the following steps.

  • On the Data tab, click Sort

The Sort dialog box appears.

  • Select First Name from the ‘Sort by’ drop-down list.

  • Click on Add Level.

  • Select Sales from the ‘Then by’ drop-down list.
  • Click OK.

Result.

Records are sorted by First Name first and Sales second.

You have been a committed learner thus far. Next, we shall look at: SORTING A RANGE ON COLOUR

Click here to enroll to our  our next Advanced Excel Training class