You need to learn about absolute and relative
see HELP as topics "About cell and range references", which points
to better topic "The difference between relative and absolute references"

Fill-Handle, Replication and use of the Mouse
http://www.mvps.org/dmcritchie/excel/fillhand.htm

--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"jim_in_Roscoe" wrote in message
...
I'm using office XP home edition
How do I compose a formula within a cell that will perform calculations
using a number from another cell.
So that when I copy the computed cell down and create a range of cells (by
dragging the cross in the lower right of the cell) all the cells in the range
perform their calculations using the number in the single original cell.