Copy formulas down a column containing data

[Gary]

When I change a formula in a column containing data, how do I copy the
formula down the column without losing the data in each cell in the column.

 

[Raz]

copy the cell and select rest of the data below and paste as paste special,
formullas