Excel 2007 when I Cut & Paste
=K62 to a new worksheet and I get
=Scenario!K62. When I copy and Paste it I get
How can I get Copy & Paste to work the same way as Cut & Paste does?
Copy and paste brings over the relative references in a formula to the new sheet.
For example, say you have the formula
= A2 + G5 in cell E2.
What get copied over to the new worksheet is "take the cell four columns to the left of the cell the formula is in and add it to the cell two columns to the right and three cells down.
If you copy the formula into a cell in the new sheet that puts one of those references "off the sheet", cell A2, for example, you get the REF! error.
Cut and paste, on the other hand, preserves the absolute references in the old sheet when you copy it to the new sheet.
This is the built-in behavior for both these actions.