Recalculating Formula - Getting the wrong answers
I'm trying to do my check book in excel. When I copy the formula in my last
column. For instance =F482-D483+E483 and then in the next column
=F483-D484+E484, etc. It is not recaluclating my formula - it is just taking
the answer from where I started my copy and copying that down. It just
started doing this - I've been doing my checkbook in excel for 3 years now.
I used to just drag and drop my balance column and it would calculate all of
the checks that I wrote and all of the deposits I made. Now it is wanting me
to manually type each formula - this can be very time consuming. Excel
allows me to drag, but it isn't recalculating the correct answer just coping
the answer from where I started my dragging from. Help!!!!
|