Pasting Formulas

J

jacob

Is there a way to copy and page formulas from one workbook to another without
it trying to link the pages to the original workbook? I pasted pages and
some of the formulas without my knowledge were linked.
 
K

Kevin B

You can copy the formula out of the formula bar, or you can press F2 and copy
the formula from inside the cell, but in either case, select everything in
the formula excluding the "=". You can then paste the formula into your
target workbook by moving to the target cell, typing an equal sign and
pressing Ctrl+V to paste the text of the formula into the cell.
 
D

Dave Peterson

Select the range to copy
Edit|replace
what: = (equal sign)
with: $$$$$
replace all

copy and paste these text strings to where you want them.

Then select that pasted range
edit|replace
what: $$$$$
with: =
replace all

Now the text strings are converted back to formulas.

Don't forget to fix the original range, too.
 
P

Peo Sjoblom

Either Dave misunderstood or you did it incorrectly, if you are trying to
copy formulas from workbook to another without carrying over the link Dave's
method does work

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
J

jacob

Sorry guys, i must not understand....

When i select the region i want to copy which is the whole worksheet and
press Edit on the menu bar and Replace, All i get is a dialog box that asks
"Find What:" and "Rreplace With:" It doesn't allow me to copy the whole
page from one book to the next or one sheet to the next.

Even if i place an equal sign in the text box or drop down box and then
select the whole workseet, I still don't get anything.

Maybe I need a few more details.

I'm using MS Office 2003

Thanks!
 
P

Peo Sjoblom

When you get that dialogue box, put the equal sign in the find what box,
then in the replace with box put the unique string like $$$$$$ or ^^^^ or
something that does not normally occurs, do the replace by clicking replace
all, THEN copy everything to the new. Then in both sheets do a reverse
replace and replace the $$$$$ with =

done



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


jacob said:
Sorry guys, i must not understand....

When i select the region i want to copy which is the whole worksheet and
press Edit on the menu bar and Replace, All i get is a dialog box that
asks
"Find What:" and "Rreplace With:" It doesn't allow me to copy the whole
page from one book to the next or one sheet to the next.

Even if i place an equal sign in the text box or drop down box and then
select the whole workseet, I still don't get anything.

Maybe I need a few more details.

I'm using MS Office 2003

Thanks!
Click to expand...
 
Top