Formula Problem in Excel 2007

[hariharan_00]

hello,
I need some help please!

I have an Excel spreadsheets where i want to work out an outstanding debts. In column C I have a weekly value, column D number of weeks owed, and column E is where I need the answer . But, I have about 100 lines on this spreadsheet. can I apply the formula to the whole of column E without having to go through every cell individually ?

Thank you

[Sam.D]

It's very simple With your values in column B and your weeks in column C (no blank rows) then you could do something like this in column D

=B1*C1 select the cell and double click the little black square in the lower right hand corner (fill-handle)

[hariharan_00]

Thanks for the help. it worked for me. I knew it would be something simple like that.

Can you give me Excel 2007 shortcuts