How can I repeat a formula don a column without manually typing it in?

You can do that by dragging the fill handle (yellow circle that will appear when the pointer is close to the bottom edge of the cell) down to fill the formula into the rest of the column.

Fill handle shown on bottom of B2:

OR

You can

• click (once) on the cell containing the formula.
• Press command-C to Copy
• scroll down to the last cell to receive the formula
• Press and hold Shift and click on that cell to add it and all cells between it and the (still selected) top one to the selection.
• Press command-V to paste the formula into all selected cells.

Regards,

Barry