I have a cell with a formula in sheet1 which points to another worksheet cell
(sheet2!$A$1). Now I want to copy this cell to another cell in sheet1, but
Excel keeps shifting the cell value in my formula (sheet2!$A$2)... How can I
tell it to just copy paste normally without excel changing my formula
targets?!

thanks!

Are you trying to paste the calculated value? Then just copy--paste
special--values.

Otherwise, one thing you could do is, instead of copying and pasting, simply
link your destination cell to the calculated cell you're trying to copy.

A third option would be to put an apostrophe to the left of the formula in
question, to convert it to a text string, copy the whole thing, paste it in
the destination cell, and then delete the apostrophe.

Dave
--
Brevity is the soul of wit.


"Ninjapowa" wrote:

I have a cell with a formula in sheet1 which points to another worksheet cell
(sheet2!$A$1). Now I want to copy this cell to another cell in sheet1, but
Excel keeps shifting the cell value in my formula (sheet2!$A$2)... How can I
tell it to just copy paste normally without excel changing my formula
targets?!

thanks!

so there is no option in Excel to give me a simple normal paste?? If I was
the one using the sheet, I do option 3, but someone with no excel experience
will be manipulating the sheet... and to add projects one under the other,
the only way I know how is copy paste....

"Dave F" wrote:

Are you trying to paste the calculated value? Then just copy--paste
special--values.

Otherwise, one thing you could do is, instead of copying and pasting, simply
link your destination cell to the calculated cell you're trying to copy.

A third option would be to put an apostrophe to the left of the formula in
question, to convert it to a text string, copy the whole thing, paste it in
the destination cell, and then delete the apostrophe.

Dave
--
Brevity is the soul of wit.


"Ninjapowa" wrote:

I have a cell with a formula in sheet1 which points to another worksheet cell
(sheet2!$A$1). Now I want to copy this cell to another cell in sheet1, but
Excel keeps shifting the cell value in my formula (sheet2!$A$2)... How can I
tell it to just copy paste normally without excel changing my formula
targets?!

thanks!

Well, there is a "simple, normal paste" which is copying and pasting a text
string. Option 3 below.

Dave
--
Brevity is the soul of wit.


"Ninjapowa" wrote:

so there is no option in Excel to give me a simple normal paste?? If I was
the one using the sheet, I do option 3, but someone with no excel experience
will be manipulating the sheet... and to add projects one under the other,
the only way I know how is copy paste....

"Dave F" wrote:

Are you trying to paste the calculated value? Then just copy--paste
special--values.

Otherwise, one thing you could do is, instead of copying and pasting, simply
link your destination cell to the calculated cell you're trying to copy.

A third option would be to put an apostrophe to the left of the formula in
question, to convert it to a text string, copy the whole thing, paste it in
the destination cell, and then delete the apostrophe.

Dave
--
Brevity is the soul of wit.


"Ninjapowa" wrote:

I have a cell with a formula in sheet1 which points to another worksheet cell
(sheet2!$A$1). Now I want to copy this cell to another cell in sheet1, but
Excel keeps shifting the cell value in my formula (sheet2!$A$2)... How can I
tell it to just copy paste normally without excel changing my formula
targets?!

thanks!

You sure?

If I used a formula like:
=sheet2!$a$1

I could copy|paste and the address never changed.

But if my formula didn't have those $'s, then the address changed.


Ninjapowa wrote:

I have a cell with a formula in sheet1 which points to another worksheet cell
(sheet2!$A$1). Now I want to copy this cell to another cell in sheet1, but
Excel keeps shifting the cell value in my formula (sheet2!$A$2)... How can I
tell it to just copy paste normally without excel changing my formula
targets?!

thanks!

--

Dave Peterson

oh yeah! that was it!!! I can't believe I didn't think of that!
thanks!!

"Dave Peterson" wrote:

You sure?

If I used a formula like:
=sheet2!$a$1

I could copy|paste and the address never changed.

But if my formula didn't have those $'s, then the address changed.


Ninjapowa wrote:

I have a cell with a formula in sheet1 which points to another worksheet cell
(sheet2!$A$1). Now I want to copy this cell to another cell in sheet1, but
Excel keeps shifting the cell value in my formula (sheet2!$A$2)... How can I
tell it to just copy paste normally without excel changing my formula
targets?!

thanks!

--

Dave Peterson