copy and paste formula with constant cell

Question

I need to make Total_Price calculation of working hours:

Excel sheet looks this way:

Job_name(A1);Time_spend(B1);Total_Price(C1);

And I have hour price in special constant cell - F1.

To get Total_Price I'm using formula =B1*F1. After this I copy cell and paste into all rest cells in C column manually. According this procedure C2 gets formula =B2*F2, but I need =B2*F1.

How to make this procedure more automatic?

Answer 1

Use absolute referencing. Instead of =B1*F1 use:

=B1*$F$1

Adding the $ signs in front of the cell references prevents the reference from changing as you drag the formula.