Question: how to copy a formula across multiple rows in excel?
Answer: Click the cell containing the formula you want to copy across the row.
Continue to hold down the mouse or track pad button, and drag the cursor across all the cells in the same row into which you want to copy the formula.