Skip to content
Related Articles

Related Articles

Improve Article

Sorting in Excel with Examples

  • Difficulty Level : Expert
  • Last Updated : 15 May, 2021

Sorting is the process of arranging the strings or integers so that they can be placed in ascending or descending order. In this article, we will look into how we can do Sorting in Excel. 

To do so follow the steps below:

Sorting Strings:

Step 1: Formatting data for sorting.

Step 2: Converting data from unsorted to sorted order in ascending order.



First, highlight the data which we want to sort.

Step 3: Then, click to Data on the Ribbon. In the Sort & Filter group, click Sort.

Step 4:- In the Sort box, select A to Z in order to sort the data in ascending order, then click Ok.

Now, data are sorted in ascending order.



Step 5: Now, if we want to sort in descending then we have to select Z to A in order to sort the data in descending order, then click Ok.

Now, data are sorted in descending order.

Sorting Integers:

Step 1: Formatting data for sorting.

Step 2: Converting data from unsorted to sorted order in ascending order.

First, highlight the data which we want to sort.

Step 3: Then, click to Data on the Ribbon. In the Sort & Filter group, click Sort.



Step 4: In the Sort box, select Smallest to Largest in Order to sort the data in ascending order, then click Ok.

Now, data are sorted in ascending order.

Step 5: Now, if we want to sort in descending then we have to select Largest to Smallest in Order to sort the data in descending order, then click Ok.

Now, data are sorted in descending order.

Attention reader! Don’t stop learning now. If you are an Excel beginner (or an intermediate) and want to learn Excel, Geeksforgeeks brings the perfect course for you to start, Diving Into Excel

My Personal Notes arrow_drop_up
Recommended Articles
Page :