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.

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.