Click on the first cell with the formula
Note the small solid square in the lower tight corner - it's called the
'fill handle
Position the mouse cursor over this - the cursor changes from a large open +
to a small solid + when you are in position
Drag the fill handle down the column
OR, if the column next to the one of interest is full of entries then double
click the fill handle to do an automatic fill to the bottom
best wishes