check book auto increment

[Guest]

Hi
I want to make a check book showing the following

date checkno Debit Credit Balance


Is it possible to move to the next line endlessly?
Like we drag the formula in last column and fill it vertically down .. lets
say 20 boxes.
I want that it should move to 21st row automatically without having the need
to fill in the formula.

the example is there in quick office, but I cant see how they made it,
formula is not visible.

Regards

 

[MyVeryOwnSelf]

I want to make a check book showing the following

date checkno Debit Credit Balance


Is it possible to move to the next line endlessly?

Here's one way, using Excel 2003.

Put your headings in A1:E1.

Then in E2 put the starting balance.

Then on E3 put
=E2-C3+D3

Then select A1:E3 and use
Data > List > Create list
and in the dialog box that appears check the box for "My list has headers."

Selecting inside the list makes an "insert row" appear at the end for
entering the next item. As items are inserted, the formula gets extended
downward.

For details, see "List" in Excel's built-in Help.