4 Advanced Features

C-c M-C-h

(ses-set-header-row). The header line at the top of the SES window normally shows the column letter for each column. You can set it to show a copy of some row, such as a row of column titles, so that row will always be visible. Default is to set the current row as the header; use C-u to prompt for header row. Set the header to row 0 to show column letters again.

[header-line mouse-3]

Pops up a menu to set the current row as the header, or revert to column letters.

M-x ses-rename-cell

Rename a cell from a standard A1-like name to any string that can be a valid local variable name (See also Nonrelocatable references).

M-x ses-repair-cell-reference-all

When you interrupt a cell formula update by clicking C-g, then the cell reference link may be broken, which will jeopardize automatic cell update when any other cell on which it depends is changed. To repair that use function ses-repair-cell-reference-all