**Excel SORT Function:** When we handle huge data, there might be numerous entries stored in it. If they are stored unordered, then it is hard to arrange them in a specific order. Usually, we need to arrange the files or data in **numerical or alphabetical order**. So, that we can easily find the data we want from that huge entries. We all know there are many formulas and functions available in Excel that will reduce the manual tasks and complete them within seconds.

In case, you want to arrange your data in the Excel spreadsheet, we suggest you use the SORT function. It always arranges the text strings in alphabetical order and the numbers in ascending or descending order. In this article, we will describe how to use **Excel SORT Function **with its syntax, explanation, and example. Get an official version of** MS Excel** from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Description of SORT Function

- It is one of the
**built-in functions**in Microsoft Excel. - The SORT function sorts the input values of the range or array in
**ascending or descending order**. - It will sort the text strings in alphabetical order. This function always returns the dynamic array of results.

## Syntax

- Here, you will see the syntax of the SORT function.
- To apply this function on your spreadsheet, you have to
**select a cell**and**enter the formula**in the following format. - Once you enter the formula, just
**click**on the**Enter**button to get the result.

**=SORT(array, [sort_index], [sort_order], [by_col])**

### Arguments Explanation

**Array –**The input range to sort.**sort_index –**It is an optional one. The column index is used for sorting. Its default value is 1.- sort_order – This option is also an optional one. Use
**1 for ascending**, and**-1 for****descending.**By default, it will sort in ascending order. **by_col –**It is an optional one. Use the value**TRUE**to sort by**column**or**FALSE**to sort by**row.**

## Example

Here, we come up with a set of examples to explore how the SORT function works in the Excel worksheet.

- Initially, you have to
**open**your**Excel workbook**on your PC and launch a worksheet that has data. - In the below example image, you can see the
**input range**in**Column B**. And, we will arrange them alphabetically using the SORT function.

- And, we have to
**apply the above-mentioned formula**in a specific cell where you want to get the output and**hit**the**Enter**button.

- Once you have executed the formula, you will get the data in ascending order, as shown in the following image.

- Let’s see one more example to make it clear. In the following image, we have shown a range of numeric values, and they are neither in ascending nor descending order.

- We will arrange the values in descending order by using the below-mentioned formula. You need to execute the following formula and
**hit**the**Enter**button.

**=SORT(B3:B7, 1, -1)**

- Finally, you will get the output, as shown in the below screenshot.

## Closure

This article gives you detailed information on how to **use Excel SORT Function** with its syntax, explanation, and practical examples. With the help of this function, you can easily sort the data in ascending or descending order. Leave your **suggestions **in the below comment box. To learn more about Excel functions, then visit our webpage Aawexcel.com.

## Video Tutorial

In this video, you will understand how to use and execute the SORT function of Excel in order to arrange the data in ascending or descending order.

**Also Read:**

- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?

**Deepak** is an Excel enthusiast and data analyst with over **5 years** of experience in the field. I’m a renowned author for AAW Excel who connects with a committed group of Excel users by imparting his professional knowledge and helpful advice. No matter your level of Excel proficiency, my articles and tutorials will teach you something new and beneficial. Connect me via my social links!… Mastodon & More!