Translations:Faq/Calc/131/8/en

    From The Document Foundation Wiki

    Procedure

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