Hi,
I face the following problem in Excel:
I entered a reference in one cell, let's say D1, to cell A1
When I cut and paste cell A1 to other location, the reference in D1 changes also to the new place (e.g. C1).
Setting the reference to absolute form, i.i. $D$1 did not help.
I need that the reference in D1 will remain the same, i.e. A1, does not matter what happens to the cell (copy, cut etc.)
Thanks,
Haim
Bookmarks