Faq/Calc/131/en

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" ()
 * Place the cursor where you want to add the line, go to  (or ). 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: (' to copy the row, then ' to paste)

Note formats, formulas. It is therefore enough to replace the values that need to be modified.
 * As the paste parameters are stored during the session, only a simple  will be needed to add more rows.
 * An alternative is to use the shortcut which recopies the previous cell (row). Everything is copied: data,

In certain cases, information is present in rows under the table, for example:

Procedure
 * Copy a row already "filled"
 * Place the cursor where you want to add the line, go to  (or ). In Selection uncheck Insert All and check Format and Formula, and the choose the option Shift cells Down.