I've been trying to create a checkbook using excel and I can not figure out how to make it stop doing what it's doing. I have no problems getting the spreadsheet to do the calculations, it's just that the cells that I have copied the formula to have the total going down though the entire E row. Is there a way using the conditional sum wizard to keep it from posting the total all the way through the E row?

A1 is the date cell
B1 is the description of transaction cell
C1 is the deposit cell
D1 is the debit cell
E1 is the balance cell

So in E3 I typed

=E2+C3-D3 and then hit enter then highlighted the E3 cell and dragged it down through the E cell to format the other cells in the E row. Everything gets calculated correctly and all totals above the last entry are what they are supposed to be, it's just all the totals below the last entry have the balance in them too which kind of bothers me because I'd like to have them remain blank until something gets entered into either the deposit or debit cell.

Does anybody know what I'm missing? Is there something I should add to the formula to hide the balances it the remaining cells?