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

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

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

$b$1

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"boneyzz" <boneyzz.22cswy_1138466701.3145@excelforum-nospam.com> wrote in
message news:boneyzz.22cswy_1138466701.3145@excelforum-nospam.com...
>
> 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
>
>
> --
> boneyzz
> ------------------------------------------------------------------------
> boneyzz's Profile:
> http://www.excelforum.com/member.php...o&userid=30927
> View this thread: http://www.excelforum.com/showthread...hreadid=506024
>

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

glad it helped

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"boneyzz" <boneyzz.22erqz_1138558502.7739@excelforum-nospam.com> wrote in
message news:boneyzz.22erqz_1138558502.7739@excelforum-nospam.com...
>
> goodness, that was so easy.. Thanks for the guidance guys!
>
>
> --
> boneyzz
> ------------------------------------------------------------------------
> boneyzz's Profile:
> http://www.excelforum.com/member.php...o&userid=30927
> View this thread: http://www.excelforum.com/showthread...hreadid=506024
>