Translations:Faq/Calc/131/4/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 the Selection area uncheck Insert All and check Format and Formula.