Copy and Paste functions in Excel 2003

[Janis]

When I copy a formula and then paste it in a cell it does
ot paste the formula, it pastes the answer to the cell I
copied it from. I know in past excel I could copy and
paste and it would transfer the formula over to the cell
I was pasting it in. Please help as I am very
frustrated. I don't want to have to go through each cell
and enter the same forumla over and over.

 

[Michael]

Janis
Try using Copy and Paste Special from the Drop down menu.
Then select Formula

Regards
Michael

 

[Janis]

I can copy and paste the formula, but it does not compute
in the cell. If I copy it from a cell with the formula
it copies the answer to the cell, but when I hit
Control/` it shows the formula. This is very
frustrating. Your help is greatly appreciated. >-----
Original Message-----

 

[Ronniev]

I place absolute values in the formula, this way if I drag
across the cell the fomula and updated answer will
display. To place the absolute value, use the F4 key in
the formula. (example =sum(d13:d27) before d and before
13 hit the F4 key, likewise for the d and 27). I if copy
and paste, I find it easier to leave the absolute value
off. Then that pasting will affect only that cell with
the fomula and specific answer. Good Luck!

 

[Vasant Nanavati]

If I copy it from a cell with the formula
it copies the answer to the cell, but when I hit
Control/` it shows the formula.<<

This is what is supposed to happen.

What would you like to accomplish?