Copying down formulas

Hi Bianca

Thanks for the question

If you are using the autofill method (Double clicking on the cell containing the value), then it will stop at the first blank row.

If you have blank rows, the you have to manually drag the formula down.

One query, is it necessary for your data to contain blank rows? If not then removing them would solve the problem and improve the apperance of your data.

Regards

Stephen