Forum Discussion
Paste formulas not working
- 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.
After spending quite enough time trying to solve this problem, I have concluded that it is a bug in the program. Hopefully Microsoft will fix it in a later update. In the meantime I have found a work-around solution. If you select Formulas from the menus at the top of the screen, then go to the group called Formula Auditing and select Show Formulas. all of the cells in the sheet will appear as formulas. I have a very useful program called Snagit which can copy an image of cells directly from the screen. I can then paste this image into Excel.
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.
Find "=" in the column or area with your formulas, Replace with an apostrophe ' before the = sign, like this: '= then formulas will be visible and can be copy-pasted. Once done, Find '= and Replace with =.
Hi JMB17
I have the same issue except I am using multiple cells in a grid.
Would you be able to offer some advice.
Kindly
Peter
- 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.
Look up "anchoring" a cell in a formula.
It is very useful for cutting and pasting formulas while keeping same column and/or row.
- 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.
