repeating formulas

[Guest]

I am trying to duplicate part of my formula in a column or row
I created a formula using a1*b1 in c1
Now i want to use
c1*a2
c1*a3
c1*a4
etc.

How can I make that happen?

Right now when I grab the plus at the bottom right if creates
c1*a2
c2*a3
c3*a4

Help please

 

[Guest]

Use an Absolute Reference to cell C1.

=$C$1*A2

The $ symbols will prevent that reference from incrementing when you copy.

HTH,
Elkar