Show All
Sort
Use the Sort dialog box to sort a range of selected cells.
Sort by
If you’re sorting rows, select the first column to sort by. If you’re sorting columns, select the first row to sort by.
Then by
Use this box if you’re sorting by more than one column or row. After the range is sorted by the column or row in the Sort By box, the range is sorted by additional columns or rows in sequence.
Ascending or Descending
Click Ascending to sort the lowest number, the beginning of the alphabet, or the earliest date first in the sorted range.
Click Descending to sort the highest number, the end of the alphabet, or the latest date first in the sorted range. Blank cells are always sorted last.
My list has
Click Header row to exclude the first row from the sort if your list has column labels in the uppermost row.
Click No header row to include the first row in the sort if the list doesn't have column labels in the uppermost row.
Options
Lets you specify a custom sort order, such as Low, Medium, High or Jan, Feb, Mar, and so forth, for the column selected in the
Sort by box. You can also specify a case-sensitive sort and sort either from top to bottom or from left to right.
Click to open the
Sort Options dialog box.
Case sensitive
Click Case sensitive to sort on capitalization. This option is not available when you sort items in a PivotTable report.
Orientation
Click Sort top to bottom to sort rows by the values in one or more columns. In PivotTable reports, you can sort by only one column.
Click Sort left to right to sort columns by the values in one or more rows. In PivotTable reports, you can sort by only one row.