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.
Doug_1 Well, it seems that the formula is pasted correctly but that the calculation just results to zero. Click in the formula bar and see which cells ar being referenced by the formula.
If you copy =+AG28/$J28*100 and paste as a formula into one cell down, formula in that cell will appear as =+AG29/$J29*100. Excel shifts relative references depends into which cell you copy the formula.
If you'd like to copy/paste it without changing the references, click on formula bar, Ctrl+A, Ctrl+C, go on another cell, Ctrl+V
- In addition to my previous post, I tried to copy directly from the editing window to the spreadsheet but that did not work either. That procedure would not be useful to me because I normally want to copy a large number of cells and past the formulas into other cells. Incidentally, I reloaded my Excel from the internet using the repair program and that did not make any difference.
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.
- Thanks for responding. On my computer CTRL+A selects every cell on the sheet. But I am not copying and pasting normally. I am trying to paste into a blank cell only the formula that has been copied, not the numerical result of the calculation of the formula.
You can Find and Replace "=" signs in the relevant column, add an apostrophe in front of the equal sign, copy-paste the needed formula(s) and then reverse the Find and Replace process.
