Please help, I'm a total Excel newbie. I need to create a spreadsheet that
works pretty much like a checkbook register. I need to be able to make daily
entries of deposits and withdrawals (dollar amounts) and keep a running
balance. I don't want the balance column to extend all the way down the
worksheet either zero (if that's the current balance) or the most recent
balance . Excel help on "Calculate the running balance" says to "copy this
formula into the current balance cell for each new transaction." Is there a
way to extend the formula without having to copy and paste it with each new
transaction? I'll have several identical worksheets for a number of different
accounts. Btw, I'm using Excel 2000. Thanks in advance for your help.