Formulas Not working when dragging down

Excel Issues/ Problem #1:


Formulas Not working when I drag it down:

when I drag a formula from the cell on downwards, the numbers remain the same in all the pasted cells. When I double click on the individual formulas, it updates.


Go to Formulas Menu -> calculation- change it to Automatic


Alternatively you can watch my below video for better clarity

if the video is not visible please click here


If you use Name ranges for cell and try to drag it down . It wont work. You should use cell Reference

Please leave your comments below if this tip is useful


    • Sujit Dsouza on February 26, 2016 at 4:33 pm
    • Reply

    Thanks a lot, it worked

    • Pooja on March 15, 2016 at 7:00 am
    • Reply

    Thanks. This really helped!

Leave a Reply

Your email address will not be published.