Question: how to make a formula in excel apply to an entire column?
Answer: Just select the cell F2, place the cursor on the bottom right corner, hold and drag the Fill handle to apply the formula to the entire column in all adjacent cells.