Copy several cells with formulas as they are?
In original cells, put absolute references (ie $A$1 instead of A1)
HTH
--
AP
"Peter Frank" a écrit dans le message de
oups.com...
Hi,
I would like to copy some cells including their formulas as they are to
another location on the same data sheet. But whenever I try to do that,
the cell references are adapted. I tried all "Insert" variations but
none worked.
I can do this for every single cell by "opening" it, selecting its
content, and copying it. But this is very tedious when I have to do
this for many cells.
So, can you tell me whether this is an easier solution to this problem?
Peter
|