Paste Special - Formulas without Adjusting References
There should be a Paste Special option to paste formulas without updating relative references.
Yes... is a cell address really "relative" if, when it is moved, it retains any part of its address?
Sheet1!A1 is not actually relative if it will still say "Sheet1" when copied to another sheet. That actually doesn't happen to me, but clearly it does to you guys so good luck!
(And I do mean just a simple copy and paste, no weird, unique, or special actions along the way). Now in the SAME sheet, well...)
I AM voting for it though since I would like an easier way to copy something like the
We want this to be able to copy Many Formulas between different Worksheets without creating a Link back to the other Worksheet.
This is particularly helpful when you have different versions of the Same Worksheet that you need to update to a fixed version.
I wish it would ask! I Never Want it to link back to the Old Worksheet! This is done quietly and behind your back and creates bugs pulling in data from another location!
This is not needed for a single formula. (Podpalov)
This would help soo Much!! Fixing this by hand is terrible...
There are some workaround but they do not work on lost of complex formulas!
You need to copy the formula from "The Formula Bar", but not cell of WorkSheet. And you will be happy.
this is definitely needed.
I was just to post about this - Paste Literal is desperately needed!
Yes, "Paste Literal" would be very helpful. That is, whatever value, reference or formula is in the cell when copied could be pasted into another cell just as if it was "moved" or "dragged." The pasted value, reference or formula would be identical to the copied value without a "relative reference" adjustment. "Paste Duplicate" might be another way to describe it.
Simone De Leonardis commented
For example if the content in Cell A1=SUM(B1:C1), you should be to paste this content: "=SUM(B1:C1)" where you want, for example in Cell A5, without locking cells. It could be useful when we have to copy and paste formulas from a workbook to another one (without the problem of REF)
Kenneth Barber commented
In the meantime...
For a single cell, you can copy the formula itself rather than a cell. For multiple cells, replace "=" with something like "t=" to force the formulas to be text. Copy and paste those cells and in both your original range and your new range, replace "t=" with "=" to restore the formulas.
Add new Paste Special feature that pastes the actual formula (rather than "Values" or the formula with offset as "Formulas" does).