Sort - Worksheet
Click the Data Tools | Data | Sort command to arrange data according to rank in user-specified sort columns. Sorting rank is based on numbers, ASCII characters, and punctuation. You can sort numeric data, text, or mixed columns.
Use the Data Tools | Data | Sort
command to sort data on multiple columns.
Selecting Cells to Sort
Sorting is performed only on the selected columns. If only one column is selected, only that column is sorted. To keep records (rows of data) together, select all columns containing data even if only one column is sorted. To decrease sort time, select a block of cells rather than clicking on the row or column labels.
Sort Order
The Sort First By option defines the primary column on which the rows are sorted. The positions of the sorted rows are determined by the Ascending or Descending rank in the Sort First By column.
Secondary Sort
When two or more rows have identical entries in the Sort First By column, the Sort Next By column can further organize the data set. Duplicates in the Sort First By column are then sorted according to the rank in the Sort Next By column.
Final Sort
The Sort Last By column can be used when the Sort Next By column contains duplicates.
Ascending or Descending Sort
The sort order in an Ascending sort is based on the ASCII table. Numeric values are placed first, followed in order by cells starting with a space character, common punctuation, numeric text (numbers entered as text), uppercase letters, less common punctuation, lower case letters, uncommon punctuation, and blank cells. Descending order is the opposite of ascending order although blank cells are still listed last.
This ASCII table shows the sort order
in the worksheet.
Ignore Case
Because sorting is based on an ASCII table, upper and lowercase letters are treated differently. For example, "A" is sorted separately from "a." If the letters are to be treated as the same during the sort, check the Ignore case option. When this check box is activated, "A" is considered identical to "a" in the sorting rank.
Labels in First Row
The data set may contain text identifying the data in the column (header information) in Row 1. In this case, click the Labels in first row option to exclude the label row from the sort process.