Forum Discussion
Paste formulas from Excel into Word not working
Hi, I am trying to copy/paste a formula from Excel into Word. The copy/paste of the formula works fine between the sheets in the workbook, but when I try in Word I keep receiving an error message th...
If you are trying to copy/paste a single formula from Excel into Word, the easiest way is to select the cell, then go to the formula bar and select the formula text. Copy it using CTRL+C, then paste it into Word.
If you need more than a single formula, an easy way would be to create a range of cells in your workbook with formulas like "=FORMULATEXT(A1)", with A1 being the appropriate references in your spreadsheet. Then you can select the range of cells that show the formula text, copy, and paste into Word. There should be no need to paste-link.
If you need more than a single formula, an easy way would be to create a range of cells in your workbook with formulas like "=FORMULATEXT(A1)", with A1 being the appropriate references in your spreadsheet. Then you can select the range of cells that show the formula text, copy, and paste into Word. There should be no need to paste-link.