How to Sort by Ascending Order in Excel (3 Easy Methods)

Every now and then, we have to Sort information in Excel to understand the data better, organize and find the data that we want. In this article, we’ll tell you the possible ways to Sort According to Ascending Order in Excel.

For ease of explanation, let’s take the following example. Here, we have taken some data of Employee Name and their Basic Pay. We’ll Sort the Names and the Pay based on Ascending Order.

sort ascending excel


Download Practice Workbook

Download the following workbook to practice by yourself.


3 Easy Methods in Excel to Sort by Ascending Order

1. Use Sort Feature in Excel to Sort in Ascending Order

We know Excel has different Tabs, Groups, Features, Tools, etc. In this method, we are going to use the Sort Feature to organize our data in Ascending Order. This feature can be applied on one column and also on multiple columns.

1.1 Sort on Single Column

To apply Sort on Single Column, follow the steps below.

STEPS:

  • First, select the Range of Cells (B5:C11) that you want to work with.

Use Sort Feature in Excel to Sort in Ascending Order

  • Then, go to the Sort & Filter feature which you’ll find in the Editing group under the Home tab.
  • There, select the Sort A to Z option as we’re sorting in Ascending Order.

Use Sort Feature in Excel to Sort in Ascending Order

  • After selecting the option, you’ll get your data organized based on Ascending Order of Employee Name.

Use Sort Feature in Excel to Sort in Ascending Order

Related Content: How to Arrange Numbers in Ascending Order in Excel Using Formula


1.2 Sort on Multiple Columns

Sometimes we have common names in our Excel datasheet. To Sort in Ascending Order of Employee Name and then by their Basic Pay simultaneously, follow these steps below.

Use Sort Feature in Excel to Sort in Ascending Order

STEPS:

  • Firstly, select the Range of Cells (B5:C11) to work with.

Use Sort Feature in Excel to Sort in Ascending Order

  • Then, go to the Sort & Filter feature which you’ll find in the Editing group under the Home tab.
  • There, select the Custom Sort option.

Use Sort Feature in Excel to Sort in Ascending Order

  • A dialogue box will pop out.
  • There, select the Employee Name in Sort by options, Cell Values in Sort On, and A to Z in the Order list.
  • Then, check the My data has headers note.

Use Sort Feature in Excel to Sort in Ascending Order

  • And then, select the Add Level tab.

  • There, select the Basic Pay in Then by options, Cell Values in Sort On and Smallest to Largest in the Order list.
  • Finally, press OK.

  • And lastly, you’ll get your data organized, first based on Employee Name, then by Basic Pay.

Read More: How to Sort Multiple Columns in Excel (5 Quick Approaches)


2. Sort by Ascending with Excel Filter Feature

Excel Filter feature serves multi-purposes. This feature can also be used to Sort data. In this method, we’ll use the Filter feature to Sort by Ascending Order.

Sort Ascending with Excel Filter Feature

STEPS:

  • Select any cell in your data range.
  • For this example, select the header ‘Basic Pay‘.

Sort Ascending with Excel Filter Feature

  • After that, go to the Sort & Filter feature which you’ll find in the Editing group under the Home tab.
  • There, select the Filter option.

Sort Ascending with Excel Filter Feature

  • After selecting you’ll see, the Down Arrow icon has appeared in the header cells.

  • To Sort the names in Ascending Order, select the Down Arrow icon.
  • A list will pop out.
  • There, select the option Sort A to Z.

  • Finally, you’ll see your data being sorted by Ascending Order of the Employee Name.

In this way, you can also sort the Basic Pay.

Read More: How to Sort and Filter Data in Excel (A Complete Guideline)


Similar Readings:


3. Excel SORT Function to Sort in Ascending Order

Our last method is to use one of many functions in Excel. Here, we’ll use the SORT function to Sort our data in column 2 by Ascending Order.

Excel SORT Function to Sort in Ascending Order

STEPS:

  • First of all, select cell E5.
  • There, type the formula:
=SORT(B5:C11,2)

Excel SORT Function to Sort in Ascending Order

  • And then, press Enter.
  • After pressing, you’ll see that the data have been arranged in the Ascending Order of Basic Pay.

Related Content: How to Use Sort Function in Excel VBA (8 Suitable Examples)


Conclusion

These above-mentioned methods can help you to Sort According to Ascending Orders in Excel very easily. Keep using them and let us know if you got any more ways to do the task in the comment section below. And feel free to drop suggestions and queries too.


Related Articles

Aung

Aung

I'm Aung. Recently I've earned my B.Sc. Degree in Electrical and Electronic Engineering. From now on, I will be working in Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo