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

"Gary" wrote:

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.