excel - Increment all numbers

Question

Suppose I have a list of numbers starting with 32,33,33.1,34 and so on. So what i am trying to achieve is , if I will replace the number 32 to 42 then all other numbers should also change like 42,43,43.1,44. Is there any way to achieve this using any editor or logic or may be in excel sheet.

Answer 1

In an excel sheet, you can use Paste Special to change all the values in one go:

1. Type 10 in a cell somewhere, and copy that cell.

2. Select the range containing the numbers and "Paste Special" > "Add".