Faq/Calc/131

    From The Document Foundation Wiki
    < Faq‎ | Calc


    How to add a row to a range (list) of data

    You have a table formatted and containing calculation formulas.

    For example :

    copie d'écran cellules formatées et colonnes calculées
    Comment continuer la saisie sans refaire formats & formules ?


    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.

    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:

    copie d'écran mêe tableau avec ligne de totaux en bas
    Comment insérer avant la ligne des totaux ?


    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.