Lesson 2: Sorting a range on multiple columns

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

Share this

Latest

Most Recent Insights

Most Popular Insights

DOWNLOADABLE RESOURCES

Categories

Related Articles

The linkage between strategy and culture

Strategy asks leaders to make choices of how they will win in the medium and long term. The focus is on how to play

Tackling Uganda’s health care challenges: Is health insurance the best option?

Mary Kyomuhendo, a senior consultant at one of the top Multi-National Companies having its subsidiary branches in Kampala has been battling serious illness following

In these tough times, empower others

Today I received a call from a car salesperson. I decided to play along. Sometimes salespeople are looking for a small break. Something to

The uncomfortable truth

Revenue does not equal growth. It does not matter how much revenue you make if your processes are inefficient or have revenue leakages where

About Author