Question: how to copy and paste a formula down a column in excel?
Answer: Enter a formula in the top cell.
Select the cell with the formula, and hover the mouse cursor over a small square at the lower right-hand corner of the cell, which is called the Fill handle. ... 
Hold and drag the fill handle down the column over the cells where you want to copy the formula.