As this is not a tutorial about absolute cell references, if you don’t know about absolute cell references, may I recommend downloading my mini-course on the subject!
The screenshot above is from a spreadsheet that is used to calculate daily expenditure on transport. The formula in C2 includes an absolute reference to F1 so that when the formula is copied down column C, the reference to F1 is retained.
An alternative approach is to assign a name to F1 (in the example below, F1 has been named “CostPerMile”) and then use the name in the formula instead of using an absolute cell reference:
When the formula is copied down column C, the reference to the named cell is left intact, i.e =B3*CostPerMile, =B4*CostPerMile, etc.