The SORT function sorts the contents of a range or array. In this example, we're sorting by Region, Sales Rep, and Product individually with =SORT (A2:A17), copied across cells F2, H2, and J2.

How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.

Learn about the SORTBY function, which sorts the contents of a range or array based on the values in a corresponding range or array. SORTBY is in a class of functions called dynamic arrays.

When you sort information in an Excel worksheet, you can see data the way you want and find values quickly, in just a few clicks. You can sort a range or table of data on one or more columns of data.

You can sort on individual values or on subtotals by right-clicking a cell, choosing Sort, and then choosing a sort method. The sort order applies to all the cells at the same level in the column that …

Sort your email messages in a way that's helpful to you. For example, sort by the name of the sender or the recipient, the date of the email message, its size, and other options.

For example, if "123" is stored as text, the sort mechanism cannot compare it to the number "123". The following table describes some issues that might occur with data values in columns, and describes …

Sort text in a table using up to three criteria and a selection of types.

You can sort a one-level bulleted or numbered list so the text appears in ascending (A to Z) or descending (Z to A) alphabetical order.

In this case, we're using the FILTER function with the addition operator (+) to return all values in our array range (A5:D20) that have Apples OR are in the East region, and then sort Units in descending …

Then, select Sort by and you’ll have the option to organize your list by Importance, Due date, Added to My Day, Alphabetically or Creation date. Select the magnifying glass icon to the right of your …