copy formula+value

[f_ringberg]

I have this 2 columns. I want to copy this two and paste them to a new
row with exact the same formula, value and cellreference.

='Z:\Företag\[filename1.xls]Bestånd'!$A$4
='Z:\Företag\[filename1.xls]Bestånd'!B18

The result:
='Z:\Företag\[filename1.xls]Bestånd'!$A$4
='Z:\Företag\[filename1.xls]Bestånd'!B29

I want the B29 to be B18. I do understand that I could change B18 to
$B$18 above but I don't want to do that. In some cases when I copy I
want the B18 to be B19,B20,B21,... and this works fine. But how could I
make a copy without changing the B18 and get the result:
='Z:\Företag\[filename1.xls]Bestånd'!$A$4
='Z:\Företag\[filename1.xls]Bestånd'!B18
====>
='Z:\Företag\[filename1.xls]Bestånd'!$A$4
='Z:\Företag\[filename1.xls]Bestånd'!B18

 

[Pete_UK]

If you put an apostrophe in front of the = sign in the second formula,
it will be converted to text, so that when you copy it it will remain
the same. Then you just need to edit the formula to get rid of the
apostrophe.

Hope this helps.

Pete

 

[RagDyeR]

Click in the cell containing the formula,
Select the *entire* formula in the formula bar,
Right click in the selection,
Choose "Copy",
Hit <Enter>

Now, just right click in any cell(s) and choose "Paste".
--

HTH,

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

I have this 2 columns. I want to copy this two and paste them to a new
row with exact the same formula, value and cellreference.

='Z:\Företag\[filename1.xls]Bestånd'!$A$4
='Z:\Företag\[filename1.xls]Bestånd'!B18

The result:
='Z:\Företag\[filename1.xls]Bestånd'!$A$4
='Z:\Företag\[filename1.xls]Bestånd'!B29

I want the B29 to be B18. I do understand that I could change B18 to
$B$18 above but I don't want to do that. In some cases when I copy I
want the B18 to be B19,B20,B21,... and this works fine. But how could I
make a copy without changing the B18 and get the result:
='Z:\Företag\[filename1.xls]Bestånd'!$A$4
='Z:\Företag\[filename1.xls]Bestånd'!B18
====>
='Z:\Företag\[filename1.xls]Bestånd'!$A$4
='Z:\Företag\[filename1.xls]Bestånd'!B18