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

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

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.

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 age, in ascending order.

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

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 …

If the chart for which you want to change the plotting order displays axes, you can quickly reverse the order in which the categories or values are plotted along those axes. Additionally, in 3-D charts that …

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 …

Learn how to highlight, sort, and filter, your tables (or data in another supported format) with Copilot in Excel.

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