copy formula using same references

  • Thread starter Thread starter macsworks
  • Start date Start date
M

macsworks

I wish to copy formula and keep the same references

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

but when I copy and paste cell G6 shows =sum(C6:E6
 
Change the cell references to be absolute: $B$2:$D$2 instead of B2:D2.
(Highlight the references up in the formula bar and hit the F4 key).
 
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. :>)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Formula 3
how to undo scrolling tied to a single cell 1
Sumifs - greater than criteria with a Cell Reference 3
I'm desperate I posted earlier about "If" statements that don't work but are correct. Now... 2
Nested IF or( If And ) can't get it to work 2
Challenge with target output 10
Excel copy and paste 1
Sum total formula for adding 2 columnson time sheet 1

Back
Top