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

In the Sort dialog box, under Column, in the Sort by or Then by box, select the column that you want to sort by a custom list. In the Custom Lists dialog box, select the list that you want.

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 …

Note: For the best results, each column should have a heading. In the ribbon, click Data > Sort. In the Sort popup window, in the Sort by drop-down, choose the column on which you need to …

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 …

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

You can sort by several columns by adding levels of sorting criteria. For example, you could sort a sales report by region, then by date, and then by salesperson.

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

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 …

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 …