Forum Discussion
excel only showing first value over again when I drag a formula down
Hi My excel seems to only show the first value of a formula over again when I try and drag it down for other values in a table please help ie 6 6 formula A1*A2 36 7 7 formula B1 *B2 36 (not 47) ...
It might be that you have accidentally turned automatic calculation off then.. go to the Formulas ribbon, calculate options and make sure Automatic is ticked.. Hopefully its currently set to manual and thats the problem.
It worked
My hats of to you and eternal gratitude
you are a genius
One simple thing has screwed me for months
I will blame my 2 yr old who often slams my keyboard pad trying to figure it out and pretend he is like his dad, just as stupid too
regards
Haha, super! Glad it worked.
just found the hot key is _m, very easy to do. I have been running my business accounts on manual for months and have no idea how much this change has effected quotes and accounting
A mistake like this could cost a business thousands in accounting