From The Document Foundation Wiki
Jump to: navigation, search


  • Copy a row already "filled" (Ctrl+C)
  • Place the cursor where you want to add the line, go to Edit ▸ Paste Special (or Ctrl+⇧ Shift+V). In Selection uncheck Insert All to keep only Format & Formula, and the choose the option Shift cells Down.