dragging formulas

Davo1 · Aug 17, 2009

when I drag a formula down, it does not grab the next row's value correctly.
It shows the result from the original cell dragged. What can I do?

David · Aug 17, 2009

what is the formula that you are trying to drag, does it have $ in it?

Luke M · Aug 17, 2009

In addition to David's suggestion, are you in manual calculation mode? Try
pressing F9.

Auto Fill formula when inserting a new line	4	Apr 20, 2011
General Setting Question	2	Apr 30, 2010
Drag formula - ignore blank cells	1	Apr 2, 2009
Continuous Invoice Nos.	3	Feb 2, 2015
Excel not recognizing formula	1	Sep 8, 2009
How do I make a cell appear blank if the value returned by the for	1	Sep 10, 2009
Problem dragging formulas	1	Feb 6, 2008
Dragging a formula across the row in 2007	2	Mar 30, 2010

Ask a Question