For example, in A1 I have '=B1', in A2 I have '=B2'.
If I copy A1 and A2, and paste it into another cell, the content may change according to its position. It will change into '=*1' and '=*2', which is the cell below the pasted area.
Notice:
1.It is possible to change content into $A$1
, but this means I have to manually change the content and then change it back. If I have to use the '$' way, if there is any short cut to switch between with '$' and without '$'?
2.A possible workaround is found here: http://www.wallstreetoasis.com/forums/how-to-copy-exact-formula-in-excel-without-changing-reference
3.A similar question. Disable Excel's Automatic Cell Reference Change After Copy/Paste
Replace the =
in the formula using Ctrl+H with another character. What I usually do is replace =
with Z=
. This will turn the formula into text since the equal sign will not be the first character in the formula.
Copy the formulas wherever you want and then do Ctrl+H and change Z=
(or whatever you chose) to =
.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments