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.

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 & …

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.

You can sort on individual values or on subtotals by pressing and holding a cell, and then choosing a sort method. The sort order applies to all the cells at the same level in the column that contains the cell.

Sort a list by days of the week or months of the year or sort by priorities in Excel. Or you can create your own custom list for items that don't sort well alphabetically.

To define a default sort order for report, use the Group, Sort, and Total pane in Layout or Design view. For step-by-step information, see the section Sort a report.

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

There may be times when you want to sort data, not by alphabetical or numerical order, but by user-defined order (also called custom or logical order). For example, sorting weekdays so that Monday …

You can sort data to arrange in: Ascending order (text is A-Z, number is smallest to largest, and date is oldest to newest). Descending order (text is Z-A, number is highest to lowest, and date is newest to …

In Excel for Mac, you can sort a list of data by days of the week or months of the year. Or, create your own custom list for items that don't sort well alphabetically. You can also sort by font color, cell color, …