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.

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.

Sort data in Excel quickly. 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 …

Sorting data can play a big role in making a report or form effective and easy to use. For example, a product catalog that lists the products in alphabetical order or on the basis of unit price is much …

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.

Sorting data is an integral part of data analysis. You might want to organize a list of names in alphabetical order or you might want to compile a list of product inventory levels from highest to lowest.

In the Sort cell, select Ascending or Descending. An ascending sort displays the record with the smallest value on top and the record with the largest value at the bottom.

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

Use a custom list to sort or fill in a user-defined order. Excel provides day-of-the-week and month-of-the year built-in lists, but you can also create your own custom list.