Forum Discussion
Excel
Do you know if it is possible to copy and paste a table with formulas, without changing the formula references (i.e. like cut and paste, without actually cutting the original table)?
It is so long since I have used a relative reference that I have forgotten the behaviour (I only use arrays and lists)! I now have a feeling of shock when duplicating a formula generates different results.
A strategy of last resort might be Ctrl/H to replace equals '=' by backslash '\' and then copy the formula as dumb text. Returning the '\' to '=' reinstates the formulas as they were. A similar strategy could be to use FORMULATEXT in some scratch area and then Copy/Paste values. You could still need 'text to columns' to commit the resulting text as a formula.