Is it possible to drag a cell down and fill cells without incrementing
one of the variables in the formula in the initial cell?

Ex. Cell C1 = A1 / B1

If you select and drag cell C1 to C10, it increments the formula: C2 =
A2 / B2, C3 = A3 / B3 ... C10 = A10 / B10.

Is there a way to lock one of the variables where you would have C2 =
A2 / B1, C3 = A3 / B1, etc.

I would prefer to not substitute the B1 variable for the B1 value.

Thanks