Copy Paste... arg...

N

Ninjapowa

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!
 
D

Dave F

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
 
N

Ninjapowa

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....
 
D

Dave F

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

Dave
 
D

Dave Peterson

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.
 
Top