Increment contents of a row by a fixed amount


I need to transform a row with numeric data by incrementing each cell by a fixed amount (e.g. 400).

How to achieve this?

Write this value (400) in free cell. Copy this cell to clipboard. Select range to modify. Press Ctrl+Shift+V. Choose Operation “Add”

Add const

Finally clear temporary cell