To copy the same formula that is in cell A2 in cell B2, C2, D2 etc. Why cant we use =A2, =A2, =A2?


3 Answer(s)


If you say =A2 then it will only copy the value in A2 and not the formula.

For that you have to ctrl+c on A2 and ctrl+v on B2, C2 and D2

If you dont put your value as =A2=B2=C2, then if you change value in A2 & it would not copy the formula, if there exists

Your question is good and it is different and unique to answer. nothing to think and excel program like any function and answer has to been taken with help of the equal to symbol. So if you mentions the symbol equal to than excel will use to that commend to solve it