how to paste formula but reference a fixed cell
 

I'm trying to paste a formula to a row, have the formula reference the
current cell as well as a fixed cell (instead of automatically incrementing).
For instance, if I were program cell C1 to be: = sum(A1/C1), and want to
copy it to the whole row, incrementing the denominator but not the numerator
so that you would get:
sum(A1/C2) sum(A1/C3)

how would you do it?

Thanks.
hr

how to paste formula but reference a fixed cell
 

Enter the formula as =$A$1/C1. The $ signs make this a fixed reference,
which means that it would increment as you copy it down or across. Check
Excel help on 'absolute vs relative references.'

"HR" wrote:

I'm trying to paste a formula to a row, have the formula reference the
current cell as well as a fixed cell (instead of automatically incrementing).
For instance, if I were program cell C1 to be: = sum(A1/C1), and want to
copy it to the whole row, incrementing the denominator but not the numerator
so that you would get:
sum(A1/C2) sum(A1/C3)

how would you do it?

Thanks.
hr

how to paste formula but reference a fixed cell
 

Use

=SUM($A$1/C1)

then copy


--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"HR" wrote in message
...
I'm trying to paste a formula to a row, have the formula reference the
current cell as well as a fixed cell (instead of automatically
incrementing).
For instance, if I were program cell C1 to be: = sum(A1/C1), and want to
copy it to the whole row, incrementing the denominator but not the
numerator
so that you would get:
sum(A1/C2) sum(A1/C3)

how would you do it?

Thanks.
hr

how to paste formula but reference a fixed cell
 

Yes that did the trick. Thank you both for a quick and helpful reply.

"bpeltzer" wrote:

Enter the formula as =$A$1/C1. The $ signs make this a fixed reference,
which means that it would increment as you copy it down or across. Check
Excel help on 'absolute vs relative references.'

"HR" wrote:

I'm trying to paste a formula to a row, have the formula reference the
current cell as well as a fixed cell (instead of automatically incrementing).
For instance, if I were program cell C1 to be: = sum(A1/C1), and want to
copy it to the whole row, incrementing the denominator but not the numerator
so that you would get:
sum(A1/C2) sum(A1/C3)

how would you do it?

Thanks.
hr