Many thanks to you Fredrick,David and Ragdyer. Every worked swell, except
the dates. I used David's =Date(2005,4,1) what that did, with the drag,
(what I just learned) and it copied the exact dates to other cells only, no
adding of month or even days, and also just entered a date. I entered like
5/1/2005. I did the wonderful feature of the drag, from the cross. (the
right one of course) but it copied everything the right way, except it
changed the days, and not the month. So there is something I'm not doing
right. If any of you like to help, I would appreciate this very much. I
could send the spreadsheet as well. I was still not able drag the Total,
pmt, yr int, Mo Int, mo prin etc down to cell # 50 or so. I can still only
do one drag at a time. Best to all of you, and many
thanks.................Peter

"Ragdyer" wrote in message
...
There's a little black square in the lower right corner of a "selected"
cell.
This is called the "fill handle".

Select the cell containing the formula.
Hover the cursor over the fill handle until the cursor changes from a fat
white cross to a skinny black cross.
Then, click and drag down to copy the formula down the column as far as
needed.

Before you do this, you should be familiar with absolute and relative cell
references.
As you drag (copy) down, the cell references in the formula will change if
they are relative, and remain the same if they are absolute.

Check this out in the Help files.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"PeterM" wrote in message
...
I'm trying to make a loan payback schedule for my daughter, and I'm
having
a
few problems. She asked me to show her what the principal is, the
payment,
the interest payments (2% she insisted) and other info she requested. I
thought I can copy and paste the formula from one completed cell to let's
say 36 others. The cut and paste works only from one cell to another, not
from one cell to several below each other. Can someone please help me
with
this? I also can't figure out how to make a date go from one date to
let's
say 36 month into the future. I'm using Excel 2003. Many many
thanks.............Peter