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.
Menu | Command | Tool | Key | Cmd-sequence |
---|---|---|---|---|
Blocks | Sort | ![]() |
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.
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.
Cell references referring to cells which move during the sort are automatically updated during a sort.
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 |