Click and drag a formula

[robdanjoe]

How do i click and drag a formula while keeping one of the values constant?

ie:
A1*C1
A1*C2
A1*C3

etc,

 

[Mike H]

Hi,

Use an absolute reference for the row. The $ sign fixes it

=A$1*C1
Mike

 

[Sheeloo]

Just put a $ before the letter and/or number you don't want to change.
$A1*C1
will keep A constant
A$1*C1
will keep 1 constant and so on.

Remember that normally letter changes if your drag to right and number
changes when you drag down...

So if you are dragging down
A$1 is same as $A$1 but different when dragged right