Forum Discussion

JHanso1993's avatar
JHanso1993
Copper Contributor
May 08, 2024

Excel formula not dragging across my rows (horizontally)

Hi,

 

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

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    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.

Resources