Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Check book register template
I just started using the Checkbook register template and love it. Until I
need to add some more rows, now the addition and subtraction feature in the Balance column doesn't work. What did I do wrong? How can I continue to put information in added rows and continue to get the Balance feature to work. Thanks for your help -- JM Hazel |
#2
|
|||
|
|||
Check book register template
When you insert a new, empty, row into a checkbook, you are usually
introducing a blank cell into a column containing formulae. You need to continue the formulae through the blanks. 1. find a blank cell with a formula above 2. select the cell and touch CNTRL-D this will copy the formula from the cell above 3. select the cell below the new (previously blank) cell and touch CNTRL-D again -- Gary's Student "JM Hazel" wrote: I just started using the Checkbook register template and love it. Until I need to add some more rows, now the addition and subtraction feature in the Balance column doesn't work. What did I do wrong? How can I continue to put information in added rows and continue to get the Balance feature to work. Thanks for your help -- JM Hazel |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Check book register template
I'm having the same difficulty of finding a way to extend/lengthen my balance
template. The Ctrl+D works great - I didn't know that - very handy. But it seems to only work for existing cells. I need more than the 12 rows allotted in this template. There doesn't seem to be any "insert rows" available. I'm using Excel 2002. What are we missing? Thanks for any more help on this. Becky "Gary''s Student" wrote: When you insert a new, empty, row into a checkbook, you are usually introducing a blank cell into a column containing formulae. You need to continue the formulae through the blanks. 1. find a blank cell with a formula above 2. select the cell and touch CNTRL-D this will copy the formula from the cell above 3. select the cell below the new (previously blank) cell and touch CNTRL-D again -- Gary's Student "JM Hazel" wrote: I just started using the Checkbook register template and love it. Until I need to add some more rows, now the addition and subtraction feature in the Balance column doesn't work. What did I do wrong? How can I continue to put information in added rows and continue to get the Balance feature to work. Thanks for your help -- JM Hazel |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Check book register template
I like the Checkbook register template for basic use, too. Does anyone know
how to add a formula to the column named "C" so that cleared checks can be checked off and my checkbook can be balanced automatically? -- J. "JM Hazel" wrote: I just started using the Checkbook register template and love it. Until I need to add some more rows, now the addition and subtraction feature in the Balance column doesn't work. What did I do wrong? How can I continue to put information in added rows and continue to get the Balance feature to work. Thanks for your help -- JM Hazel |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Check book register template
Hi Joyce
One way would be to add a column I called Cleared balance. Click on the column header for column H to select it, click the Format painter icon, then click column I, and that will get the appearance the same. In cell I6 enter =H6 In cell I7 enter =$I$6-SUMPRODUCT(--($E$7:E7="x"),--($F$7:F7-$G$7:G7)) and copy down. Then, if you put an x in column E (Labelled "C"), then column I will reflect the cleared balance down to that transaction. -- Regards Roger Govier "Joyce" wrote in message ... I like the Checkbook register template for basic use, too. Does anyone know how to add a formula to the column named "C" so that cleared checks can be checked off and my checkbook can be balanced automatically? -- J. "JM Hazel" wrote: I just started using the Checkbook register template and love it. Until I need to add some more rows, now the addition and subtraction feature in the Balance column doesn't work. What did I do wrong? How can I continue to put information in added rows and continue to get the Balance feature to work. Thanks for your help -- JM Hazel |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Check book register template
Thanks, it took a while to "translate" your formula into the template I had
already modified to suit my needs but, it WORKED!!! -- J. "Roger Govier" wrote: Hi Joyce One way would be to add a column I called Cleared balance. Click on the column header for column H to select it, click the Format painter icon, then click column I, and that will get the appearance the same. In cell I6 enter =H6 In cell I7 enter =$I$6-SUMPRODUCT(--($E$7:E7="x"),--($F$7:F7-$G$7:G7)) and copy down. Then, if you put an x in column E (Labelled "C"), then column I will reflect the cleared balance down to that transaction. -- Regards Roger Govier "Joyce" wrote in message ... I like the Checkbook register template for basic use, too. Does anyone know how to add a formula to the column named "C" so that cleared checks can be checked off and my checkbook can be balanced automatically? -- J. "JM Hazel" wrote: I just started using the Checkbook register template and love it. Until I need to add some more rows, now the addition and subtraction feature in the Balance column doesn't work. What did I do wrong? How can I continue to put information in added rows and continue to get the Balance feature to work. Thanks for your help -- JM Hazel |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Check book register template
Hi Joyce
Thanks for the feedback. That's the problem when one doesn't know anything about the layout at the other end. I just worked off the standard template. Glad you managed to sort it all out though. -- Regards Roger Govier "Joyce" wrote in message ... Thanks, it took a while to "translate" your formula into the template I had already modified to suit my needs but, it WORKED!!! -- J. "Roger Govier" wrote: Hi Joyce One way would be to add a column I called Cleared balance. Click on the column header for column H to select it, click the Format painter icon, then click column I, and that will get the appearance the same. In cell I6 enter =H6 In cell I7 enter =$I$6-SUMPRODUCT(--($E$7:E7="x"),--($F$7:F7-$G$7:G7)) and copy down. Then, if you put an x in column E (Labelled "C"), then column I will reflect the cleared balance down to that transaction. -- Regards Roger Govier "Joyce" wrote in message ... I like the Checkbook register template for basic use, too. Does anyone know how to add a formula to the column named "C" so that cleared checks can be checked off and my checkbook can be balanced automatically? -- J. "JM Hazel" wrote: I just started using the Checkbook register template and love it. Until I need to add some more rows, now the addition and subtraction feature in the Balance column doesn't work. What did I do wrong? How can I continue to put information in added rows and continue to get the Balance feature to work. Thanks for your help -- JM Hazel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you set up a formula ( as for a check book.) | Excel Discussion (Misc queries) | |||
How do I get a Template to write a Book ? | New Users to Excel | |||
check register template | Excel Discussion (Misc queries) | |||
how : check register running balance is a stationary cell | Excel Discussion (Misc queries) | |||
Where are instructions for using Check Register template in Excel. | Excel Discussion (Misc queries) |