I would like to copy the formula in one cell to another without adjusting
cell references within the formula. For example

Cells(10,10).formula=cells(2,2).formula

will copy the formula in B2 to J10 without adjustment. There must be a
simple way to do this without resorting to VBA??

--
Gary's Student

Select the entire formula in the formula bar.

Right click in the selection, and choose "Copy".

Hit <Enter.

Right click in J10, and choose "Paste".

And you're done.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gary's Student" wrote in message
...
I would like to copy the formula in one cell to another without adjusting
cell references within the formula. For example

Cells(10,10).formula=cells(2,2).formula

will copy the formula in B2 to J10 without adjustment. There must be a
simple way to do this without resorting to VBA??

--
Gary's Student

And if you have range of cells to do this to, then select the range and do
Edit / Replace / Replace = with %%. Copy to new place, and then do Edit /
Replace / Replace %% with =.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ragdyer" wrote in message
...
Select the entire formula in the formula bar.

Right click in the selection, and choose "Copy".

Hit <Enter.

Right click in J10, and choose "Paste".

And you're done.
--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Gary's Student" wrote in message
...
I would like to copy the formula in one cell to another without
adjusting
cell references within the formula. For example

Cells(10,10).formula=cells(2,2).formula

will copy the formula in B2 to J10 without adjustment. There must be a
simple way to do this without resorting to VBA??

--
Gary's Student

Then, if you want the original formulas to still work at their original
location, go back to them and also revert the change back to it's original,
while the Edit - Replace dialog window still remembers the replace
settings.<g
--
Regards,

RD

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


"Ken Wright" wrote in message
...
And if you have range of cells to do this to, then select the range and do
Edit / Replace / Replace = with %%. Copy to new place, and then do Edit /
Replace / Replace %% with =.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--

"Ragdyer" wrote in message
...
Select the entire formula in the formula bar.

Right click in the selection, and choose "Copy".

Hit <Enter.

Right click in J10, and choose "Paste".

And you're done.
--
HTH,

RD


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

--------------------------------------------------------------------------
-
"Gary's Student" wrote in
message
...
I would like to copy the formula in one cell to another without
adjusting
cell references within the formula. For example

Cells(10,10).formula=cells(2,2).formula

will copy the formula in B2 to J10 without adjustment. There must be
a
simple way to do this without resorting to VBA??

--
Gary's Student

Thank you
--
Gary's Student


"Ken Wright" wrote:

And if you have range of cells to do this to, then select the range and do
Edit / Replace / Replace = with %%. Copy to new place, and then do Edit /
Replace / Replace %% with =.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ragdyer" wrote in message
...
Select the entire formula in the formula bar.

Right click in the selection, and choose "Copy".

Hit <Enter.

Right click in J10, and choose "Paste".

And you're done.
--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Gary's Student" wrote in message
...
I would like to copy the formula in one cell to another without
adjusting
cell references within the formula. For example

Cells(10,10).formula=cells(2,2).formula

will copy the formula in B2 to J10 without adjustment. There must be a
simple way to do this without resorting to VBA??

--
Gary's Student

LOL - That too :-)

--
Regards
Ken.......................


"Ragdyer" wrote in message
...
Then, if you want the original formulas to still work at their original
location, go back to them and also revert the change back to it's
original,
while the Edit - Replace dialog window still remembers the replace
settings.<g
--
Regards,

RD

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


"Ken Wright" wrote in message
...
And if you have range of cells to do this to, then select the range and
do
Edit / Replace / Replace = with %%. Copy to new place, and then do Edit
/
Replace / Replace %% with =.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)

--------------------------------------------------------------------------
--

"Ragdyer" wrote in message
...
Select the entire formula in the formula bar.

Right click in the selection, and choose "Copy".

Hit <Enter.

Right click in J10, and choose "Paste".

And you're done.
--
HTH,

RD



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


--------------------------------------------------------------------------
-
"Gary's Student" wrote in
message
...
I would like to copy the formula in one cell to another without
adjusting
cell references within the formula. For example

Cells(10,10).formula=cells(2,2).formula

will copy the formula in B2 to J10 without adjustment. There must
be
a
simple way to do this without resorting to VBA??

--
Gary's Student