how to paste formula but reference a fixed cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.'
 
Back
Top