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

By default Excel will sort by row, and will only sort by column where by_col is TRUE. When by_col is FALSE or missing Excel will sort by row. The SORT function is provided to sort data in an …

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.

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

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 …

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 …

In the Sort row, select Ascending or Descending for each of the expressions. An ascending sort in the first column displays January at the top and December at the bottom. An ascending sort in …

In Excel, you can sort numbers, text, weekdays, months, or items from custom lists that you create. You can also sort by font color, cell color, or icon sets. Sorts can be case-sensitive. …

When you sort based upon multiple columns, the order or hierarchy of the sorting is based on the order that the columns were selected. Repeat steps 2 and 3 for each subsequent column you …