Mar 11

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

About the author

Ragavan Rajan

I'm Ragavan Rajan - Lead Business Improvement, Innovation & Development, having professional experience in SharePoint 2010 / SharePoint 2013, Windows 7, Windows 8, One note, VB Script, Excel and VBA.


  1. Sujit Dsouza

    Thanks a lot, it worked

  2. Pooja

    Thanks. This really helped!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">