Be able to pastspecial the content (basically the code) of a specific Cell without entering in the cell and select/copy the line
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)
You can do this in Excel already today. Instead of copying the entire cell (by selecting the cell in the grid), double click on the cell to enter edit mode, select the formula, and copy it.
Paste that into the destination and it won’t adjust.