How do i keep it like this, A1:c1/b1, A2:c2/b1, A3: c3/b1?

[boneyzz]

When i drag down the formula from Cell A1, it goes like this, cell
A1:c1/b1, cell A2:c2/b2, cell A3: c3/b3, cell A4:c4/b4 and so on..

I would like the formula to be like this, cell A1:c1/b1, cell A2:c2/b1,
cell A3: c3/b1, cell A4: c4/b1 ..

How do i keep it constant at b1? Any form of assistance will be
appreciated. Thanks in advance!

Regards,
Matt

 

[Don Guillett]

$b$1

 

[Ron Coderre]

Switch from this:
A1: =C1/B1


to this:
A1: =C1/B$1
Then copy that formula down.

(The dollar sign in a reference "locks in" that part of the
reference.)

Does that help?

Regards,
Ron

 

[boneyzz]

goodness, that was so easy.. Thanks for the guidance guys!

 

[Don Guillett]

glad it helped