Something is worng with my copy and paste.
When I try to copy a formula from one cell and apply it to another it doesn't work. I get the same number from the original cell instead of the corresponding sum. I don't know what the problem is. Also I've tried doing it by special paste too.
(I hope I explained this clear enough for you)
2007-09-06 07:03:28 · 8 answers · asked by pagie83 2 in Computers & Internet ➔ Software
Try pressing the F9 key at the top of your keyboard. You may have the manual calculation turned on. :)
2007-09-06 07:25:29 · answer #1 · answered by pricehillsaint 5 · 0⤊ 1⤋
Go to tools, options, calculation and then make sure Automatic is clicked. That should work. You can also paste special formulas.
Make sure you formula is not written to only refrence the same cells as the cell your copying. For example if you have
=sum(A1:A10) your formula should copy over ok but if your formula is =Sum($A$1:$A$10) you will always get the same answer because you are locking the cells.
Hope this helps
2007-09-06 14:14:04 · answer #2 · answered by JB 3 · 1⤊ 1⤋
Check the formatting of the destination cell. Make sure it is formatted the same as the original cell. You can also try to delete the row or column and re-insert it, then try to copy and paste the formula again. Sometimes that works. Once in awhile I've found that a cell is "bad" and I just can't get it how I want it. Perhaps it's "user error"! Hope this helps.
2007-09-06 14:07:00 · answer #3 · answered by Stimpy 7 · 0⤊ 1⤋
Do the cell references contain "$"?
This is a direct reference symbol. If you have $A$1 it will always look at call A1 no matter where you paste it. If the reference is simply A1 then it should adjust dynamically when you paste is elsewhere.
If C1 = A1+B1 and you copy it to C2, C2 should contain the formula A2+B2.
If C1 = $A$1+$B$1 and you copy it to C2, C2 would still reference $A$1+$B$1.
I hope this helps.
2007-09-06 14:14:16 · answer #4 · answered by Jeremie I 4 · 1⤊ 1⤋
Copy / paste will give initial answer, as it takes the entire formula as is.
if you want a "similar" formula in columns 1,2,3 and have entered it in 1. Look for the small black dot in lower right corner of cell, click and hold it and drag out to covers cells 2 and 3.
This will move and adjust the formula accordingly.
2007-09-06 14:06:53 · answer #5 · answered by stu_the_kilted_scot 7 · 0⤊ 2⤋
try copying the formula and pasting that instead copying the cell value
2007-09-06 14:06:34 · answer #6 · answered by ehsaas 4 · 0⤊ 2⤋
when you select the cell to copy from click it once and not double click then when you select paste sspecial it will give you options, select format
2007-09-06 14:07:32 · answer #7 · answered by Z 6 · 0⤊ 1⤋
when you select the cell to copy from, click it once and not double click. when you select paste special, it will give you options, select format
2007-09-06 14:14:34 · answer #8 · answered by kat 1 · 1⤊ 2⤋