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.

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 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.

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.

Sorting data is helpful when you have large amounts of data in a PivotTable or PivotChart. You can sort in alphabetical order, from highest to lowest values, or from lowest to highest values. Sorting is one …

Type the word or phrase you’re looking for and we’ll check for that search term in all of your tasks, steps, tags and notes. We’ll return a list of each instance we’re able to find that word or phrase. You can …

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 …

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 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.