Suppose A1 and B1 have numbers, and C1 has =A1+B1
And the A2:A5 and B2:B4 also have numbers
If you copy C1 down the column, you will see numbers in C cells but if you
look in the Formula Bar you will see Formulas. Cells display results;
Formula Bar displays formula

by the way, the quickest way to copy a formula down a column is to double
click its fill handle - small solid square in right lower corner of active
cell. This trick works when an adjacent column has something in it.

best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"lucdol" wrote in message
...
I am using MS Excel 2003. How do I copy a formula all the way down a
column
without copying the data inside the cell too? When I entered the formula
in
the second cell of the last column and got my total. I copied the formula
in
the cell and went down. It copied the formula but also copied the total?
Now if I delete the total I also delete the formula? Help me please.
Sincerely, Lucy