# Amortization Table For X Year Mortgage

• Hello, I'm trying to make an amortization table with all the individual payments. I'm trying to avoid putting in the formula manually into each individual cell. I have a formula =ROUND(F11*0.12/12,0) and I want to insert that formula down an entire column, but increasing the F11 to F12, F13, etc. I'd greatly appreciate it if someone could help me out on this, thanks.

## Files

• Re: Creating Amortization Table For 30 Year Mortgage

Hi

Copy and Paste should do just that

Robert

• Re: Creating Amortization Table For 30 Year Mortgage

I"m sorry, I don't think I explained well enough.. Say there's two rows, row C and F. A cell in Row C has the formula = ROUND(F11*0.12/12,0). I want to put this formula down all the cells in row C, but for the next cell in the column, the formula would go from F11 to 12, 13, etc. The attachment might be able to help better visualize what I'm trying to say.

• Re: Creating Amortization Table For 30 Year Mortgage

Hi

Did you try Copy & Paste? Did it not copy the formual and change the reference?

Robert

• Re: Amortization Table For X Year Mortgage

angryirishman0, you came here for help, correct? So, why not at the VERY least, try the help you are given?

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!