# Inserting rows in a Checkbook Register

##### New Member
Hi All,
I've been looking for a free checkbook register template that will automatically calculate the balance as you add or subtract various amounts.

I found one which seemed to be just what I wanted but once I had reached the end of the rows for the worksheet and tried to add more rows the automatic feature quit working.

I found another Checkbook Register which seemed even better than the first one as it had a notation at the end of the rows.
It said to " Insert new rows above this point" and it had the last row greyed out.
I tried adding a new row and tested it out by adding some amount but it did not continue with the automatic calculation either.

I'm sure there must be a simple way around this but can't figure out just what it could be, so I'm hoping that someone can give me a few pointers.
I'm using MS Excel for Mac 2011
Thanks

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
Hi and welcome to the forum
Try something like this

Excel 2007
ABCDE
5DateDescriptionDepositsExpenditureBalance
6
7
8Starting Balance\$ -
925/12/2002Wages\$ 1,000.00\$ 1,000.00
1026/12/2002Rates\$ 300.25\$ 699.75
1127/12/2002food\$ 50.00\$ 649.75
1228/12/2002wages\$ 900.00\$ 1,549.75
1329/12/2002food\$ 75.00\$ 1,474.75
1430/12/2002petrol\$ 40.00\$ 1,434.75
1531/12/2002wages\$ 1,000.00\$ 2,434.75
161/01/2003food\$ 120.00\$ 2,314.75
Sheet1
Cell Formulas
RangeFormula
E9=IF(B9="","",IF(C9<>"",E8+C9,E8-D9))
E10=IF(B10="","",IF(C10<>"",E9+C10,E9-D10))
E11=IF(B11="","",IF(C11<>"",E10+C11,E10-D11))
E12=IF(B12="","",IF(C12<>"",E11+C12,E11-D12))
E13=IF(B13="","",IF(C13<>"",E12+C13,E12-D13))
E14=IF(B14="","",IF(C14<>"",E13+C14,E13-D14))
E15=IF(B15="","",IF(C15<>"",E14+C15,E14-D15))
E16=IF(B16="","",IF(C16<>"",E15+C16,E15-D16))

Hi Michael, thanks for the prompt response.
I'm afraid all of that is over my head, I'm looking for the register to be already formatted for the auto. calc so I don't have to do anything but enter data.
I really appreciate all of the work you have done to illustrate it for me.

well, it's fairly simple....copy the block of data into your worksheet and then copy each formula into the respective cell reference.
Notwithstanding that, you'll just have to keep googleing to find what suits you.
Try googling "Bank balance" or "Home Budget"

Thanks again Michael for the suggestions,

Replies
3
Views
81
Replies
0
Views
118
Replies
1
Views
282
Replies
3
Views
363
Replies
2
Views
186

1,196,073
Messages
6,013,275
Members
441,759
Latest member
ab_

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back