Excel 2002 Copying Exact formulas

K

Kinjalip

Is there a way to copy a formula from one cell to another cell to get the
same answer. When attempting to copy a formula from one cell to another, the
column and row destinations are changing in the formula, with a result of 0
not he original solution.
Thanks
 
J

JulieD

Hi

if you use absolute referencing the formula should not change, e.g. use
=SUM($A$1:$A$100)
instead of
=SUM(A1:A100)
 
G

Guest

Hi
You'll need to make the references absolute. So instead of
=A2+A3
use
=$A$2+$A$3
This means that when the formula is copied and pasted, the reference to the
original cells remains.
 
D

Dave Peterson

If you only have one formula to copy|paste, then copy from the formula bar and
paste into the formula bar.

If you have lots, you can change the formulas to text:
edit|replace
what: =
with: $$$$$= (some unique string)
replace all

copy|paste normally

edit|replace
what: $$$$$=
with: =
replace all
(both in the source and destination ranges)
 
R

RagDyeR

When copying from the formula bar, don't forget to hit <Enter> or <Esc>
before pasting to the new cell.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

If you only have one formula to copy|paste, then copy from the formula bar
and
paste into the formula bar.

If you have lots, you can change the formulas to text:
edit|replace
what: =
with: $$$$$= (some unique string)
replace all

copy|paste normally

edit|replace
what: $$$$$=
with: =
replace all
(both in the source and destination ranges)
 
Top