«

»

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

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.

2 comments

  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="">