copy formula using same references

[macsworks]

I wish to copy formula and keep the same references

ie
cell F2 has formula =sum(B22)
copy this to cell G6 so that
cell G6 shows =sum(B22)

but when I copy and paste cell G6 shows =sum(C6:E6

 

[Guest]

Change the cell references to be absolute: $B$2:$D$2 instead of B22.
(Highlight the references up in the formula bar and hit the F4 key).

 

[macsworks]

thanks to bpeltzer

problem solve

 

[Dana DeLouis]

Another option is to copy your formula from the Formula Bar at the top.
Copying from the formula bar does not put Excel into Linking mode.

HTH. :>)