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

### 3.2 Resizing the spreadsheet

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)`).