Next: Printer functions, Previous: Formulas, Up: The Basics [Contents][Index]

Basic commands:

`C-o`(

`ses-insert-row`

)`M-o`(

`ses-insert-column`

)`C-k`(

`ses-delete-row`

)`M-k`(

`ses-delete-column`

)`w`(

`ses-set-column-width`

)`TAB`Moves point to the next rightward cell, or inserts a new column if already at last cell on line, or inserts a new row if at endline (

`ses-forward-or-insert`

).`C-j`Linefeed inserts below the current row and moves to column A (

`ses-append-row-jump-first-column`

).

Resizing the spreadsheet (unless you’re just changing a column width) relocates all the cell-references in formulas so they still refer to the same cells. If a formula mentioned B1 and you insert a new first row, the formula will now mention B2.

If you delete a cell that a formula refers to, the cell-symbol is
deleted from the formula, so `(+ A1 B1 C1)`

after deleting the third
column becomes `(+ A1 B1)`

. In case this is not what you wanted:

`C-_``C-x u`Undo previous action (

`(undo)`

).