Copy formulas and maintain original cell references?

  • Thread starter Thread starter bostitch
  • Start date Start date
B

bostitch

I want to copy a group of formulas and paste them several
rows away from the originals, and I need to maintain the
exact same cell references as the originals.

Is there a copy special, or some other technique, that is
less laborious than manually adding $'s to each variable
in all the eqs?

TIA
 
One way is to click in the cell with the formula and then select the
*entire* formula in the *formula bar*.
Hit <Enter>, and then right click in new location and choose Paste.

Another way might be to select the *entire* formula in the formula bar and
then you just have to hit the F4 key *once*, and *all* the references will
change to absolute, enabling you to copy in the normal fashion.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Select your range to copy.
Edit|Replace
Replace: = (equal sign)
with: $$$$$$= (some unique set of characters)

Now your formulas are just plain old text.

Copy them as text and paste them as text.

Then undo what you did (for both ranges!)
Select
Edit|replace
replace: $$$$$$=
with: =
 
Dave Peterson's suggestion, posted before your post, addresses your
question.
Is it that you are not able to see his post on your news reader, or that you
do not understand it ?

--

Regards,

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

-----Original Message-----
One way is to click in the cell with the formula and then select the
*entire* formula in the *formula bar*.
Hit <Enter>, and then right click in new location and choose Paste.

Another way might be to select the *entire* formula in the formula bar and
then you just have to hit the F4 key *once*, and *all* the references will
change to absolute, enabling you to copy in the normal fashion.
--

HTH,

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




.But what if you have a long column of formulas and you
Click to expand...
don't want to touch each and every cell
 
Gina

Select your range of formulas to copy or cut.

Edit>Replace

Replace what: =
Replace with: xxx

Copy or cut to new location then reverse the Replace procedure.

Gord Dibben Excel MVP XL2002
 
Back
Top