Next: , Previous: Ranges in formulas, Up: Advanced Features

3.3 Sorting by column

C-c M-C-s
Sort the cells of a range using one of the columns (ses-sort-column). The rows (or partial rows if the range doesn't include all columns) are rearranged so the chosen column will be in order.
[header-line mouse-2]
The easiest way to sort is to click mouse-2 on the chosen column's header row (ses-sort-column-click).

The sort comparison uses string<, which works well for right-justified numbers and left-justified strings.

With prefix arg, sort is in descending order.

Rows are moved one at a time, with relocation of formulas. This works well if formulas refer to other cells in their row, not so well for formulas that refer to other rows in the range or to cells outside the range.