Forum Discussion

RDawes22's avatar
RDawes22
Copper Contributor
Oct 15, 2020
Solved

Unable to replicate formulas automatically anymore

I have been creating a formula for example =sum(B5-100)  usually you can grab the bottom right corner and drag it down to replicate the same formula. I am unable to do so now and it just has the cros...
excel
  • Simon33's avatar
    Simon33
    Oct 15, 2020

    RDawes22 

    Excel --> Options --> Advanced --> In "Editing Options" (Normaly it is the first part of Advanced Options)

     

    Check "Enable fill handle and cell drag-and-drop"  is checked 

     

    Hope this will help

Simon33's avatar
Simon33
Copper Contributor
Oct 15, 2020

RDawes22 

Excel --> Options --> Advanced --> In "Editing Options" (Normaly it is the first part of Advanced Options)

 

Check "Enable fill handle and cell drag-and-drop"  is checked 

 

Hope this will help

RDawes22's avatar
RDawes22
Copper Contributor
Oct 15, 2020

Simon33 Thank you, all sorted