Cannot drag formulas

[Lester Bender]

Here is the situation. Excel 2010. Drag formulas is turned on. Autocalculate is turned on. I have 23 rows of numbers I wish to multiple against one cell. Initial cell as the formula: cell E2 = D2*E1 the next cell should be cell E3=D3*E1. But when dragging it simply copies the formula in cell E2. the same happens when I drag across the cells to copy the formula in cells E3-E5 where the formulas should be D2*F1 through D2*H1

[sathiyamoorthy]

hi,

for first one try this E2=$D2*$E$1 AND DRAGG IT TO DOWN.


THANKS,
SATHYA

[Andy Pope]

you need to use $ to hold absolute references

= D2*$E$1

= $D$2*F1

[Lester Bender]

Thanks. This is not the way it used to be! Thanks again. problem solved

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.