Ask Your Question

Increment contents of a row by a fixed amount [closed]

asked 2012-11-12 19:36:47 +0100

anonymous user



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

How to achieve this?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 00:28:13.484426

1 Answer

Sort by » oldest newest most voted

answered 2012-11-12 20:50:36 +0100

JohnSUN gravatar image

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

edit flag offensive delete link more

Question Tools


Asked: 2012-11-12 19:36:47 +0100

Seen: 3,642 times

Last updated: Nov 12 '12