ExcelBanter - Copy Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Copy Formula (https://www.excelbanter.com/excel-programming/418186-copy-formula.html)

Mike H.

Copy Formula

I have a formula in a cell. The formula is: =150+200
I wish to copy that formula and place it in another workbook as =150+200 and
not the resulting value 300. How do I do this?

DMoney

Copy Formula

copy - pastespecial formulas.

"Mike H." wrote:

I have a formula in a cell. The formula is: =150+200
I wish to copy that formula and place it in another workbook as =150+200 and
not the resulting value 300. How do I do this?

Sheeloo[_2_]

Copy Formula

Select the formula in the edit mode (not the value)
Go to the cell you want it in
Type ' then CTRL-V and ENTER

btw 150+200 is 350 :-)

"Mike H." wrote:

I have a formula in a cell. The formula is: =150+200
I wish to copy that formula and place it in another workbook as =150+200 and
not the resulting value 300. How do I do this?

All times are GMT +1. The time now is 03:54 AM.