Adding a constant in LibreOffice Calc


How do you add a constant to a group of cells in LibreOffice Calc?

For example, here are four cells:

47 28 35 62

Now add 3 to each cell:

50 31 38 65

Best Answer

  • Even easier, but overwriting the original values:

    • Copy the Constant using Ctrl+C
    • Select the values that should get changed;
    • Use "Paste Special" (Edit -> Paste Special or Ctrl+Shift+V), select "Add" as Operation:

    Paste Special - 2

    Result: the values are replaced by the result of the addition with the constant.

  • Related Question