Put all your data in a table, then when you create the first formula in a column it will automatically populate the entire column.

Also the formulas expand and contract with your table.

No more copying formulas.