Hi all,
When I cut data from a specific cell, and paste it to another cell -
all the formulas are changes accordinally... is there any option that
the formulas will not cahnge ?

Thanks a lot. neta Dekel


--
neta
------------------------------------------------------------------------
neta's Profile: http://www.excelforum.com/member.php...fo&userid=7624
View this thread: http://www.excelforum.com/showthread...hreadid=538855

Nope, other then Copy and Clear.

--
Jim
"neta" wrote in message
...
|
| Hi all,
| When I cut data from a specific cell, and paste it to another cell -
| all the formulas are changes accordinally... is there any option that
| the formulas will not cahnge ?
|
| Thanks a lot. neta Dekel
|
|
| --
| neta
| ------------------------------------------------------------------------
| neta's Profile:
http://www.excelforum.com/member.php...fo&userid=7624
| View this thread: http://www.excelforum.com/showthread...hreadid=538855
|

"neta" wrote:
When I cut data from a specific cell, and paste it to another
cell - all the formulas are changes accordinally... is there
any option that the formulas will not cahnge ?

None that I know of. Two alternatives that may or may not
be useful for you.

1. Change the original formula to use absolute references;
for example, $A$1 instead of A1. You can do this by
editing the original formula and for each relative reference,
press F4 until you see the absolute reference ($A$1, $A1,
A$1) that will work for you when you copy the cell.

2. Go into edit mode for the original cell, and cut the text of
the formula in the "fx" field in the toolbar. Press Esc to
exit edit mode, then go to the new cell and paste the text.