Copy without Adjustment

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
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.
 
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 =.
 
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>
 
Thank you
--
Gary's Student


Ken Wright said:
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 =.
Click to expand...
 
LOL - That too :-)

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


Ragdyer said:
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 said:
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 :-)
--------------------------------------------------------------------------
--



--------------------------------------------------------------------------
Click to expand...
benefit
!

--------------------------------------------------------------------------
Click to expand...
be
Click to expand...
 
Back
Top