Quick start: Sort data in an Excel worksheet - Microsoft Support
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 …
Sort data in a range or table in Excel - Microsoft Support
How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.
SORT function - Microsoft Support
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, …
Sort data in a PivotTable or PivotChart - Microsoft Support
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. …
Sort data using a custom list - Microsoft Support
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.
Reapply a filter and sort, or clear a filter - Microsoft Support
After you have filtered or sorted data in a range of cells or table column, you can either reapply a filter or perform a sort operation to get up-to-date results, or you can clear a filter to redisplay …
Change the plotting order of categories, values, or data series
In the Select Data Source dialog box, in the Legend Entries (Series) box, select the data series that you want to change the order of. Select the Move Up or Move Down arrows to move the …
Clear or remove a filter - Microsoft Support
If you can’t find specific data in a worksheet, it may be hidden by a filter. For example, if you have a column of dates in your worksheet, that column may have a filter that restricts the values to …
SORTBY function - Microsoft Support
The SORTBY function sorts the contents of a range or array based on the values in a corresponding range or array. In this example, we're sorting a list of people's names by their …
Create or delete a custom list for sorting and filling data
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.