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)?
3 Replies
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.
Have you tried to Copy and then paste using any of the options on the Paste....Special.... Dialog box?
Hello Mathetes,
I tried but I could not find any suitable options. The only way was to use F4 to fix the references in the original formulas.
Thanks and best regards,
Riccardo
