Originally Posted by homealone

if copying vertically, just highlight the cells with the formulas in, then left click on the little black square in the bottom right of the highlighted cells & drag downwards for as far as you want the formulas to apply.