How to Copy a Formula to Other Cells in Excel
Write a formula once, then copy it to the other rows. Excel adjusts the cell references as it pastes, so row 11's copy uses row 11's cells, while references with $ signs stay pointing at the same cell. Select, Ctrl+C, select the target cells, Ctrl+V (Cmd+C and Cmd+V on a Mac).
