I am building a financial forecast and have 10 columns representing years 1-10.
Functions such as IPMTand PPMT use the same base parameters such as PV,
Rate, NPer etc. and and in the forecast each builds on the results of the
year before.

How can I copy and paste the first year's formula into a row for each of the
remaining years and have the formula refer to its base parameters w/out
editing every formula's parameters over and over again?

XP 2003