Need help please

[ExcelUser2011]

How do you make that an entire column to use the same code without the need to copy and paste to all the lines and also that it shouldn't look like
0
0
0
0
0
Meaning :
A = Invoice Number
B = Invoice Amount
C = Amount Paid
D = Balance

All of column C and D are all totaled up on each column, I want that for the entire sheet it should constantly add together without me to paste the code on each line seperately.

CHEERS

 

[GK039]

I guess D = B-C. If so then in cell D1 put =B1-C1 and drag with the fill handle the formula all the way down

George

How do you make that an entire column to use the same code without the need to copy and paste to all the lines and also that it shouldn't look like
0
0
0
0
0
Meaning :
A = Invoice Number
B = Invoice Amount
C = Amount Paid
D = Balance

All of column C and D are all totaled up on each column, I want that for the entire sheet it should constantly add together without me to paste the code on each line seperately.

CHEERS

 

[ExcelUser2011]

I think I wasn't clear with my request. Thanks though for taking your time to answer.

I don't want to "drag with the fill handle the formula all the way down" I want that the entire column should have the formula without the need for me to do so (copy and paste or drag etc.).

Cheers.

 

[GK039]

Make a list if you are using 2003, from data list. To add an entry use TAB in the last row. In 2007-2010 make a table. Formulas are being added automaticallly

I think I wasn't clear with my request. Thanks though for taking your time to answer.

I don't want to "drag with the fill handle the formula all the way down" I want that the entire column should have the formula without the need for me to do so (copy and paste or drag etc.).

Cheers.