copy cells with formula without references

M

macsworks

I wish to copy cells containing formula to another cell but when I paste
I want the
the formula I to have the same references as the original cell
 
N

Niek Otten

Instead of, for example, =A1, use =$A$1
This can also be achieved by pressing F4 when the cursor is on the address
in the formula bar.
 
Top