Forum Discussion
Solved
Paste formulas not working
If I copy a value that has been generated by a formula in Excel and paste into a different cell and then try to convert the value in the cell to appear as a formula by using the available methods, it...
- It sounds like you want to paste the formula text?
If you have the formulatext function, you could use it to reference the cell containing the formula:
=FormulaText(A1)
Alternatively, you could try formatting the cell as text and the copy paste the formula from the formula bar to the destination cell.
If my understanding of what you're trying to do is correct, then the paste special-formula behavior is not a bug as it has always pasted in the formula as an expression to be evaluated.
Thanks very much for you help JMB17. I tried the formulatext function and was able to display the formulas for a selection of cells in a location of my choosing. That is exactly what I wanted to do.
Look up "anchoring" a cell in a formula.
It is very useful for cutting and pasting formulas while keeping same column and/or row.
- Hello BruceIan20, Thanks for the information. Anchoring the cell works find for a single cell but I have more than 100 cells that I need to work with. I don't think the method is practical for multiple cells.