Mar 11

Formulas Not working when dragging down

Excel Issues/ Problem #1:

Issue:

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.

Solution:

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

Note:

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

2 comments

    • 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.