The original table
A formula for A2="A1"
The formula for "in the A3=A2"
The formula for "in the A4=A3"
The formula for "in the A5=A4"
The formula for "in the A6=A5"
.
Question:
(1) in the middle of the line 1 and line 2 insert row, will find no formula, the A2 and A3 in the formula for="A1" (for "=A2")
(2) delete the second line, you'll find A3, A4, A5, A6... , all error
Please master how to solve,
It is best not to make the code, thank you
CodePudding user response:
This does not need to code,All you need is to find M $program ape to fix it this BUG,
CodePudding user response:
Drag the formula, or double-click the,, won't point click on it...Solve the second problem can solve with other formulas, such as INDIRECT, example:=an INDIRECT (" A "& amp; The ROW () - 1)
Solve the first problem, don't need to insert, and on the basis of the second question, with the entire line to copy, and then "insert replication cell" to solve, but really it is better to mop it simple...
CodePudding user response: