Excel formula not dragging across my rows (horizontally)

Copper Contributor



I need assistance with dragging a formula across my rows, however it's just copying the same figure across and not updating the formula as it goes across.


e.g    =1491578/4.71

1 Reply

@JHanso1993 And how would the formula have to be updated? In other words, what should the formula become when you drag it across one cell? You are just dividing one number by another. There are no cell references in the formula.