Copy Formula

  • Thread starter Thread starter Mike H.
  • Start date Start date
M

Mike H.

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?
 
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 :-)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Copying data to another workbook 1
Lookup Table 1
How to use Sumifs with vertically and horizontally criterias 3
seeking a smarter lookup function 6
hide multiple worksheets based on a formula value in one cell 1
Change data value in a range of cells 5
IF FUNCTION 0

Back
Top