Sorting

You can sort a block of cells on the document on any column, in either ascending order or descending order. Text cells are sorted alphabetically, number cells in numerical order of their value and dates in date order.

  1. Mark the block.

    Note that you need to mark all the columns containing cells to be sorted. If you mark only a few fields (columns), only those will be sorted. Usually, the best way to ensure that enough columns are marked is to mark all columns by dragging Select down the row borders.
  2. Give the Sort command
Menu Command Tool Key Cmd-sequence
Blocks Sort Sort icon BSO

By default, the sort will be in ascending order. To reverse this, click the Ascending order option to turn it off. You can set this option independently for each column you type in.

If you do not type in a column reference, the sort will take place on the column containing the caret. Note that part of or all of the column must be within the marked block.

Sorting on Several Columns

You can sort records on up to five columns. The sort takes place in the order in which you enter the columns in the Sort dialogue box. The order of the sort can be set individually for each column.

Sorting Cell References

Cell references referring to cells which move during the sort are automatically updated during a sort.

Sorting Multi-Row Records

To sort multi-row records, you must have the Multi-row records option in the Sort dialogue box turned on. The blank cells between the multi-row records ensure that when you sort the records on column A, all the rows in the record will be kept together.

For information on See
Sorting multi-row records Database Use