Sorting Data

You are here:
< Back

In this post we will try to understand how to sort data in excel.

Sort could be performed on single column and multiple columns in excel and sort order could either be ascending (Low to High) or descending (High to Low).

We could also perform sort on the basis of a custom list that we could create and tell excel to perform the sort on the basis of the custom list (We have explained this here sort by custom list in excel).

But in this section we will understand sorting on one and more than one column.

Below is the sample data which we will use to explain sort in excel, the data has country, sales and he month of sales figure.

Sample data to explain sort on single column and sort on multiple column

Sort on single column

We will try to understand sort on single column by sorting below data alphabetically on country column.

Select entire data and click on sort symbol in Data tab in excel.

Click on sort icon to sort data

You will get sort menu as shown below, select country from column drop down and select A to Z from order drop down and then press OK.

select column on which you want to sort data

Now you could see below the data is sorted by country in ascending order.

sorted data on single column

To sort data in descending order select Z to A from order drop down.

Sort on Multiple Column

Suppose now we want to further sort the data by date descending.

We have already sorted the data by country ascending and now we want to add one more sort level on date column.

To do that, add one more column by clicking “Add Level” icon as shown in the figure below and then select Month from Column drop down and since we want our data to be sorted by country ascending and month descending, so select Oldest to Newest from Order drop down and press OK.

add another column to sort on multiple column

As we could see below our data is sorted by country ascending and month descending.

 

data is sorted on multiple columns

The way we have added second column to sort on, we could add as many columns as we desire to sort data.

There are other types of sorts too like sort by cell color, sort by font color which we have explained in different section.

Random Posts

  • Vlookup First Word In Excel

    In this post we will see how could we vlookup for first word in a string, here string could be […]

    Share The Knowledge
  • Excel Assign Row Number If Cell Is Not Blank

    automatically assign row number if data is not blank in excel, assign row number to non blank data in excel, assign row number to all non blank values in excel

    Share The Knowledge
  • Sort By Length In Excel

    In this article we will see how we could sort by length in excel i.e.We may have some data arranged in a […]

    Share The Knowledge
  • Extract Numbers After A Character In Excel

    Let’s see how we could easily extract all the digits after a character in excel. There are several occasions in […]

    Share The Knowledge