Copy and Paste functions in Excel 2003

  • Thread starter Thread starter Janis
  • Start date Start date
J

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.
 
Janis
Try using Copy and Paste Special from the Drop down menu.
Then select Formula

Regards
Michael
 
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-----
 
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!
 
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?
 
Back
Top