Translations:Faq/Calc/131/8/en
Procedure
- Copy a row already "filled" (Ctrl + C)
- Place the cursor where you want to add the line, go to ▸ ▸ (or Ctrl + ⇧ Shift + V). In Selection uncheck Insert All and check Format and Formula, and the choose the option Shift cells Down.