Insert and delete
- Select whole rows or columns, or a range of cells, to act on.
- Use the Insert and Delete buttons, or right-click a row or column heading.
- Use the Clear button to clear All, Formats or Contents from the selection.
- Press Ctrl+Shift++ to insert, or Ctrl+- to delete: on a range of cells a window asks whether to shift the cells right or down (left or up), or to insert/delete entire rows or columns; you can also right-click a cell and choose Insert… or Delete….
- Each operation is a single undo step and repoints all affected formulas, just like Excel.
Tip Press Ctrl+9 / Ctrl+0 to hide rows or columns, and Ctrl+Shift+9 / Ctrl+Shift+0 to unhide them.