Help from Microsofthttps://support.microsoft.comWhen sorting information in a worksheet, you can rearrange the data to find values quickly. You can sort a range or table of data on one or more columns of data. For example, you can sort employees —first by department, and then by last name.
Select the data to sort
Select a range of tabular data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). The range can include the first row of headings that identify each column.
Sort quickly and easily
Select a single cell in the column you want to sort.
On the Data tab, in the Sort & Filter group, click
to perform an ascending sort (from A to Z, or smallest number to largest).
Click
to perform a descending sort (from Z to A, or largest number to smallest).
Sort by specifying criteria
Use this technique to choose the column you want to sort, together with other criteria such as font or cell colors.
Select a single cell anywhere in the range that you want to sort.
On the Data tab, in the Sort & Filter group, click Sort to display the Sort popup window.
In the Sort by dropdown list, select the first column on which you want to sort.
In the Sort On list, choose Values, Cell Color, Font Color, or Cell Icon.
In the Order list, choose the order that you want to apply to the sort operation—alphabetically or numerically, ascending or descending (that is, from A to Z (or Z to A) for text, or lower to higher, or higher to lower for numbers).
See moreSee lessWatch full video
- Watch full videoSee more
SORT function - Microsoft Support
Learn how to use the SORT function to sort the contents of a range or array in Excel. See syntax, examples, and tips for using SORT with other functions and dynamic arrays.
See results only from support.microsoft.comUnique Function
Tips: If you format the range of names as an Excel table, then the formula will …
Sortby Function
Need more help? You can always ask an expert in the Excel Tech Community or …
Sequence Function
In addition, you could use =SEQUENCE (5,1,1001,1000) to create the sequential …
Filter Function
How to use the FILTER function in Excel to filter a range of data based on criteria …
Contact Microsoft
Contact Microsoft Support. Find solutions to common problems, or get help from a …
Surface
Choose from a variety of Surface devices and accessories to get help.
Microsoft Rewards
Earn rewards with Microsoft. Just by simply doing what you love to do. Sign in or …
Implicit Intersection Operator
The implicit intersection operator was introduced as part of substantial upgrade …
How to Use SORT Function in Excel? - ExcelDemy
SORT function in Excel (How to - 6 Examples) - Excel Off The Grid
- SORT returns an array of rows and columns. In this example, a single formula sorts the values in …
- SORT by another column in descending order. Example 2 shows how to sort by the second column …
- SORT expands automatically when linked to a Table. The animation below shows how the SORT …
- Using SORT to return a top 5 and specific columns. Example 4 shows how to create a top 5 and …
- Combining FILTER and SORT. The dynamic array functions can be nested within each other. This …
How to Use the Microsoft Excel SORT Function
Nov 9, 2022 · While Microsoft Excel offers a built-in tool for sorting your data, you may prefer the flexibility of a function and formula. We'll show you how to use the Excel SORT function with helpful examples.
Excel SORT function | Exceljet
Nov 2, 2023 · In this video, we’ll look at how to sort by multiple columns with the SORT and SORTBY functions. In this worksheet, we have a list of names, projects, values, and regions.
SORT function in Excel - Step by Step Tutorial
Learn how to use the SORT function in Excel 365/2021 to sort your data by one or more columns. See examples, arguments, spilling, and SORTBY function.
- People also ask
Excel SORT function - auto sort data using formula
Mar 14, 2023 · Learn how to use the SORT function in Excel to sort data arrays dynamically by columns or rows, in ascending or descending order. See examples of basic and advanced usage, tips and notes, and common issues.
Mastering the Excel SORT Function: The Ultimate Guide
Mar 28, 2025 · With its non-destructive, real-time sorting capabilities and dynamic arrays, this comprehensive guide covers everything: from basic syntax to advanced multi-column sorting, error handling, and troubleshooting.
Excel SORT Function: Sort Excel Data Using a Formula …
Aug 30, 2024 · Learn how to use the SORT function to sort data in ascending or descending order by one or more columns in Excel. See examples, tips, and limitations of this dynamic array function and how to combine it with other …
How to Use the SORT Function in Excel (With Examples) …
Using different examples, let’s learn the SORT function syntax and applications for vertical and horizontal sorting. Whether you are a beginner or an advanced user, this article is all you need to master the SORT function.
