Coping formulas

[Cathryn Arco]

Hi

Normally when I input a formula into a cell I then click on the bottom right hand corner of the cell and drag the formula down the sheet and this works really well.

I have a spreadsheet however that when I do this it is just copying down the value that was returned in the first cell and not recalculating the formula as it goes down the column.

Does anyone know why this would be happenning and how to correct? I have tried to copy and paste the formula and this hasn't fixed it.

thank you
Cathryn

 

[Sektor]

Hold Control.

 

[Cathryn Arco]

Hi
No that didn't fix the problem, it is still copying the same value all the way down. Any other suggestions?

 

[Sektor]

Check Calculation Mode: Formulas tab -> Calculation Options -> Automatic.

 

[Cathryn Arco]

Yes, that worked!! Fantastic, thank you