Copy and paste values, formatting and formulas
If you are copying just a few formulas, copy them from the source formula bar
and paste into the formula bar on target sheet in target workbook.
If you have many to do I would suggest this method.
Select all formula cells then EditReplace
What: =
With: ^^^
Replace all.
Copy to the target then reverse the process on both books or just the target and
close source without saving.
The second question requires a two-step operation.
1. Copy and paste specialvaluesokesc
2. Paste SpecialformatsOKEsc.
Gord Dibben MS Excel MVP
On Fri, 29 Feb 2008 08:19:03 -0800, Joe M.
wrote:
I have a couple of problems.
If I try to copy a formula from one workbook to another new one to use the
formula in the new one it adds the name of the originating spreadsheet as
reference. I have to go through each formula and delete the name reference to
the original spreadsheet. How do I prevent that?
Next problem; when copying a workskeet that contains cell formating, color
etc how to I copy the values and formatting but not the formulas?
|