Frequently asked questions - Calc
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
How to add a row to a range (list) of data
You have a table formatted and containing calculation formulas.
For example :
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 the Selection area uncheck Insert All and check Format and Formula.
A new row is inserted, containing the formats and the formulas. The procedure is much faster to execute than to describe: (Ctrl + C to copy the row, then Ctrl + ⇧ Shift + V to paste)
Note
- As the paste parameters are stored during the session, only a simple Ctrl + ⇧ Shift + V will be needed to add more rows.
- An alternative is to use the shortcut Ctrl + D which recopies the previous cell (row). Everything is copied: data,
formats, formulas. It is therefore enough to replace the values that need to be modified.
In certain cases, information is present in rows under the table, for example:
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.