In addition to Bernard's advice, make sure ToolsOptionsCalculation is set to
Automatic.


Gord Dibben MS Excel MVP

On Sun, 11 Feb 2007 09:03:00 -0800, lucdol
wrote:

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