To do analysis or to keep numbers in order, **Sorting** is important. In Excel, there are a couple of ways to **Sort **numbers. There are two possible ways to **Sort** numbers: one is **Smallest to Largest**, and another is vice versa. In this article, I’m going to explain how to perform Excel **Sort **numbers.

To make the explanation understandable, I’m going to use a sample dataset that contains the salary information of a particular employee. The data has **3 **columns; these are ** Employee Name**,

**, and**

*Region***.**

*Salary*

**Table of Contents**Expand

## How to Sort Numbers in Excel (8 Easy Ways)

### 1. Sort Numbers from Smallest to Largest in Excel

You can **sort** the numbers from **Smallest to Largest** using the **ribbon **feature.

Let me demonstrate to you the procedure,

To begin with, select the cell range that contains **numbers**.

➤ I selected the cell range **D4:D13**.

Open the **Home** tab >> go to **Editing** >> from **Sort & Filter** >> select **Sort Smallest to Largest**

A **dialog box** will pop up. From there select **What do you want to do?**

In **What do you want to do?** There are two options one is “**Expand the selection” **another is “**Continue with the current solution”**.

**➤ Expand the selection** means it will **sort** the numbers along with their adjacent cell values which will maintain the relationship between cells.

**➤ Continue with the current solution** means it will only **sort** the numbers the adjacent values won’t change it will remain as it is. The problem is it will change the number’s position for that reason it may lose its relation to its adjacent cell.

⏩ As I want to maintain the relationship, I selected the option **Expand the selection**.

Then, click on **Sort**.

Hence, it will **Sort **the numbers in the **Smallest to Largest **order along with the adjacent cell values.

**Read More: **How to Arrange Numbers in Ascending Order with Excel Formula

### 2. Sort Numbers from Largest to Smallest in Excel

If you want, you can **Sort** the numbers from **Largest to Smallest **using the **ribbon **feature.

To start with, select the cell range that contains **numbers**.

➤ I selected the cell range **D4:D13**.

Open the **Home** tab >> go to **Editing** >> from **Sort & Filter** >> select **Sort Largest to Smallest**

A **dialog box** will pop up. From there select **What do you want to do?**

⏩ I selected the option **Expand the selection**.

Then, click on **Sort**.

Therefore, it will **Sort **the numbers in **Largest to Smallest **order along with the adjacent cell values.

### 3. Sort Numbers Based on Criteria in Excel

In case you want to **Sort** numbers based on criteria you can do it by using the **Custom Sort** feature.

To begin with, select the cell range that contains **numbers**.

➤ I selected the cell range **D4:D13**.

Open the **Home** tab >> go to **Editing** >> from **Sort & Filter** >> select **Custom Sort**.

A **dialog box** will pop up. From there select **What do you want to do?**

⏩ I selected the option **Expand the selection**.

Then, click on **Sort**.

Another **dialog box** will pop up. From there click on **Add Level**

In **Sort by** select the **Column **name based on which you want to **Sort** your **numbers**.

In **Then by** select the **Column** which contains the **numbers**.

⏩ I selected the **Region** column in **Sort by** and in **Order** selected **A to Z**.

⏩ I selected the **Salary($)** column in **Then by** and in **Order** selected **Smallest to Largest**.

Then, click on **OK**.

As a result, it will **Sort** the numbers based on the **Region **column with the order **Smallest to Largest**. Here, each **Region **will contain the **smallest **and **largest** values.

If you want, you can **Sort** numbers based on criteria from **Largest to Smallest**. To do so follow the steps I **explained earlier**.

⏩ I selected the **Region** column in **Sort by** and in **Order** selected **A to Z**.

⏩ I selected the **Salary($)** column in **Then by** and in **Order** selected **Largest to Smallest**.

Then, click on **OK**.

Hence, it will **Sort** the numbers based on the **Region **column with the order **Largest to Smallest**. Here, each **Region **will contain the **largest **and the **smallest **values.

*If you want, you can use the Sort command from the Data tab to use the Custom Sort.*

*Open the Data tab >> select Sort it will open the dialog box to apply the custom sort.*

**Read More: **How to Put Numbers in Numerical Order in Excel

### 4. Using Excel Formula to Sort Numbers in Ascending Order

If you only want to **Sort **numbers in an **Ascending (Smallest to Largest)** order, then you can use **the SMALL function **and **the ROWS function** together.

Here, If you want you can use the entire number range with **absolute reference** or you can **name **the cell range of numbers you are going to use.

I **named** the range **D4:D13 **as **data_1**.

To begin with, select any cell to place the resultant value.

➤ I selected cell **F4**.

⏩ In cell **F4** type the following formula.

`=SMALL(data_1,ROWS($D$4:D4))`

Here, in the **SMALL** function, I used the **named range data_1** as an **array **and **ROWS($D$4:D4)** as **k **(it is the position in a range of data that starts from the smallest).

Then, in the **ROWS **function, I selected the range **$D$4:D4** as an **array **that will return the position. Here, I used **absolute reference **so that I can use it for the remaining cells.

Now, the **SMALL **function will extract the **Smallest** number from the given range of data.

Press **ENTER** then you will get the **Smallest **number from the used **named range**.

⏩ You can use the **Fill Handle** to autofill the formula for the rest of the cells.

Here, all the numbers are sorted in ascending order.

**Read More: **How to Sort Numbers with Letter Suffix in Excel

### 5. Using Excel Formula to Sort Numbers in Descending Order

Similar to the previous section, we can use **the LARGE function **and the **ROWS** function to **Sort** the numbers, but this time the functions will sort in **Descending **order.

Here, I **named** the range **D4:D13 **as **data_2**.

To start with, select any cell to place the resultant value.

➤ I selected cell **F4**.

⏩ In cell **F4** type the following formula.

`=LARGE(data_2,ROWS($D$4:D4))`

Here, in the **LARGE** function, I used the **named range data_2** as an **array **and **ROWS($D$4:D4)** as **k **(it is the position in a range of data that starts from the largest).

Then, in the **ROWS **function, I selected the range **$D$4:D4** as an **array **that will return the position.

Now, the **LARGE **function will extract the **Largest** number from the given range of data.

Press **ENTER** then you will get the **Largest **number from the used **named range**.

⏩ You can use the **Fill Handle** to **AutoFill** the formula for the rest of the cells.

Here, all the numbers are **Sorted** in **Descending **order.

### 6. Sort Numbers Using Excel Context Menu

If you want, you can **Sort** numbers using the **context menu**.

To demonstrate the procedure, I’m going to use the dataset given below where I added two columns one is **Tax to Pay**, and another is **Tax Percentage** to show you how different** Number Formats** work while **Sorting**.

To begin with, select the cell range from which you want to **sort** the **numbers**.

➤ I selected the cell range **F4:F13**.

Now, **right-click on the mouse** then from **Sort** >> select **Sort Largest to Smallest**

A **dialog box** will pop up. From there select **What do you want to do?**

⏩ I selected the option **Expand the selection**.

Then, click on **Sort**.

Hence, it will **Sort** the numbers in **Largest to Smallest** order along with the adjacent cells’ values.

**Read More: **How to Sort Duplicates in Excel

### 7. Using A→Z Command to Sort Numbers Smallest to Largest

From the **Data **tab, you also can **Sort** numbers using the sorting command **A→Z**. It will sort the numbers from **Smallest to Largest**.

To start with, select the cell range that contains **numbers**.

➤ I selected the cell range **D4:D13**.

Open the **Data** tab >> select **A→Z**

A **dialog box** will pop up. From there select **What do you want to do?**

⏩ I selected the option **Expand the selection**.

Then, click on **Sort**.

Hence, it will **Sort **the numbers in the **Smallest to Largest **order along with the adjacent cell values.

**Read More: **How to Sort Merged Cells of Different Sizes in Excel

### 8. Using Z→A Command to Sort Numbers Largest to Smallest

By using the **Z→A** command you can **Sort** the numbers from **Largest to Smallest**.

To start with, select the cell range that contains **numbers**.

➤ I selected the cell range **D4:D13**.

Open the **Data** tab >> select **Z→A**

A **dialog box** will pop up. From there select **What do you want to do?**

⏩ I selected the option **Expand the selection**.

Then, click on **Sort**.

Therefore, it will **Sort **the numbers in **Largest to Smallest **order along with the adjacent cell values.

**Read More: **How to Sort Merged Cells in Excel

## Things to Remember

🔺 While using **Custom Sorting **remember to check the **My data has headers **option.

🔺 If you don’t want to change shuffle your data then you will need to select the **Expand the selection** option.

## Practice Section

I’ve provided a practice sheet to practice the explained methods.

**Download to Practice Workbook**

You are welcome to download the practice workbook from the link below.

## Conclusion

In this article, I have shown 8 ways Excel **Sort **numbers. These ways will help you to remove **Sort** numbers easily based on your requirements. Feel free to comment down below for any types of queries and suggestions.

## How to Sort Numbers in Excel: Knowledge Hub

- Arrange Numbers in Ascending Order in Excel Using Formula
- Put Numbers in Numerical Order in Excel
- Sort Numbers with Letter Suffix in Excel

**<< Go Back to Sort in Excel | Learn Excel**

arrangement a 4 digit number in a row from lowest to highest.

What`s the formula ?

Dear SATHI,Thank you very much for reading this article. Here, you have a query to arrange a 4-digit number in a row from the lowest to highest using a formula. We have found a solution for your mentioned problem in the below section.

● Look at the below image.

A four-digit number is inserted in the dataset.

● First, we will separate the digits of the inserted number using the following formula.

=MID($B5,COLUMN()-(COLUMN($E4)- 1),1)We use the combination of the

MIDandCOLUMNfunction.Formula Explanation:●COLUMN($E4)This will return the column number of the reference.

Result: 5● COLUMN($E4)-1We will subtract 1 from the column number.

Result: 4● COLUMN()It returns the column number of the inserted cell.

Result: 5● COLUMN()-(COLUMN($E4)-1)A subtraction operation will apply here.

Result: 1● MID($B5,COLUMN()-(COLUMN($E4)- 1),1)The

MIDfunction will operate here.Result: 6● Now, we will sort the separated numbers using the formula based on the

SORTfunction.=SORT($E$4:$H$4, ,1,TRUE)You can also download the following Excel file for practice.

Solution Excel Sort Numbers.xlsx