Copy without adjusting

[Guest]

Dear All,

In old versions of Excel (or was it Supercalc 1.0!) you were able to copy formula with an option to 'not adjust' - meaning any cells refferences were unaltered. I know you can $A$1 etc but sometimes you need to 'not adust' and then later adj etc. ie: it's a pain to have to insert and then remove $$. Any thoughts?

Thanks
Peter

 

[Ron de Bruin]

Hi Peter

No easy way

For one cell you can type a apostrophe before the formula to make it text
'=a1+b1

Or for a range
Select your copy range and use Edit>Replace in the
Menu Bar.

Use replace "=" to " =" (see the space before =)
Without quotes


--
Regards Ron de Bruin
http://www.rondebruin.nl

Dear All,

In old versions of Excel (or was it Supercalc 1.0!) you were able to copy formula with an option to 'not adjust' - meaning any

cells refferences were unaltered. I know you can $A$1 etc but sometimes you need to 'not adust' and then later adj etc. ie: it's a
pain to have to insert and then remove $$. Any thoughts?

 

[RagDyer]

To copy a range of cells that contain formulas, Ron's suggestion of somehow
revising the primary "equal" sign is probably the easiest approach.

On the other hand, to copy a *single* formula to other cells, probably the
easiest approach is to select the entire formula in the formula bar, right
click and choose "Copy", and then hit <ENTER>.

You can now right click in any cell and choose "Paste", and you'll end up
pasting the *exact* formula that you copied.
--

HTH,

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


Hi Peter

No easy way

For one cell you can type a apostrophe before the formula to make it text
'=a1+b1

Or for a range
Select your copy range and use Edit>Replace in the
Menu Bar.

Use replace "=" to " =" (see the space before =)
Without quotes


--
Regards Ron de Bruin
http://www.rondebruin.nl

Dear All,

In old versions of Excel (or was it Supercalc 1.0!) you were able to copy

formula with an option to 'not adjust' - meaning any
cells refferences were unaltered. I know you can $A$1 etc but sometimes you
need to 'not adust' and then later adj etc. ie: it's a
pain to have to insert and then remove $$. Any thoughts?