How to copy a formula in excel down a column

If you have a formula into a cell and you want to apply this formula to the entire column, because all the data in that column must be calculated in the same way, proceed as follows.

Step 1 – Select formula you want to copy down the column

– Select the cell by clicking on it or with the keyboard arrows.

Step 2 – Copy the formula down the column

– Move the cursor to the bottom right border of the selected cell. The cursor will change into a black cross;
– Double click on the border to copy the formula down the column.