Sorting

You can sort the fields of your spreadsheet. Sorting is a way of re-arranging items in a specific order, according to the contents of a key row or column within the selection.

To sort rows and columns in a spreadsheet, first shade the range to be sorted. Then select the Sort command from the Tools menu. The "Sort" dialog box is displayed.

In the Sort box, you can choose between sorting by Rows and sorting by Columns.

In the three boxes below the Sort box, you can specify up to three sort levels. For each sort you should specify which column to sort by when sorting rows, or which row to sort by when sorting columns.

For each sort you can also choose between Ascending order (where normal ascending numerical or alphabetical order is applied) and Descending order (where normal descending order is applied). Normal sort order can be overridden by selecting a Custom List from the Order box. This enables you to sort columns or rows that contain, for example, days of the week or months, or any lists that you may have added to Custom List yourself.

If you apply more than one sort, columns or rows with duplicates in the first sort level are sorted according to the second and third sort levels. If you have not specified second and third sort levels, rows or columns with duplicates in the first sort are left in the order in which they are found.

To sort on more than three levels, use the Sort command several times using the least significant keys first.

Note that when a sort is applied using Normal order, the following criteria apply: