software

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
Use an Absolute Reference to cell C1.

=$C$1*A2

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

HTH,
Elkar

quot;sunrockquot; wrote:

gt; I am trying to duplicate part of my formula in a column or row
gt; I created a formula using a1*b1 in c1
gt; Now i want to use
gt; c1*a2
gt; c1*a3
gt; c1*a4
gt; etc.
gt;
gt; How can I make that happen?
gt;
gt; Right now when I grab the plus at the bottom right if creates
gt; c1*a2
gt; c2*a3
gt; c3*a4
gt;
gt; Help please
gt;
gt;