If you would like to copy your formulas *without* changing the references
from relative to absolute, you can simply copy the formula to the clipboard,
and then paste it anywhere, as many times as you wish, without having the
cell references change.

Select the *entire* formula in the formula bar.
Right click in the selection and choose "Copy".
HIT <Enter
*OR*
<Esc

Now, paste anywhere, and as many times as you wish, without having the cell
references change.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"avjunior" wrote in message
...
How do I copy cells with relative references into other cells kepping the
same references? e.g. cell A3 has the formula A1+A2. A6 has the formula
A4+A5. I want to copy A3 and A4 into A15 and A16 in order to have A15 with
the formula A1+A2 and A16 with the same formula as A6 (A4+A5).