Answer: I’m your formula, after inserting B6 press F4
Explanation: in order to absolute reference the cell B6 in the formula for cells B8-B11, the cell B6 must have the dollar sign as such $B$6 this is to ensure that when copying the formula across B9-B11, it does not change to B7-B9 respectively