suppose cell A1 has formula "=B1+C1", if B1 is 2 and C1 is 3, A1's value will be 5.
Now, I'd like to "clone" cell A1 to B4, how could i do that?
If I just copy and paste, cell B4's formula would actually be "=C4+D4". This is the same if I just copy & paste, or choose "paste special" then "formula".
I could "cut and paste", then B4's formula would be "=B1+C1", but A1 will be empty.
How could I "clone" the content of A1 to B4?
--- additional note:
I know the difference of "B1", "B$1", "$B1" and "$B$1". I'd like to know a way that general to any of these kinds of usage.