Enter 2 in an empty cell, copy the cell, select the area to add (or row or column), select Paste Special in the right-click menu, select Value and Add, and then click OK
In this way, I suggest that you enter a number to add in a blank space, such as 100, copy - paste it selectively, select "Add" at the bottom "Operation", and confirm.In this way, you can add 100 to all the places you need to add.,
If the number is between A1 and A100, enter 100 in any empty cell, select this cell, copy, and select A1: A100 - Right click - Paste Selectively - Value - Add. OK
If this column is column A, create a new column B. Enter=A2-A1 in B2, and then drag it down.Filter the rows greater than 1 in the final result. If the value is X, add X-1 rows to that row.This also needs to be added line by line, but it can save you from finding which lines need to be added!If you want to implement your requirements in batches, you can only program, I will not.