[Emper0r]

Hey guys, I'm trying to make an amortization table. But how I'm doing it right now is going to take me forever. Basically, what I'm trying to do is take the Beginning Balance in each row and multiply it by the set monthly interest rate at the top to come up with the monthly interest payment. However, I'm entering the formula for each row in the interest payment rows. The formula is for example: =PRODUCT(B54,D47). Is there a way that I can take this formula and apply it to every row in the interest payment column without having to change the B value (Beginning balance) each time manually? Thank you very much for any help and here's a picture so you get a visual:

[bla!!]

Yup, just click on one of the cells that already has the formula in it.
Edit the formula to say

=PRODUCT(B54,D$47)

Then click and hold on the square in the lower right of the cell.

Drag down as far as you want the formula to apply. Excel will auto increment the B Value. The $ tells excel not to increment the D value.