copy formulas from one worksheet to an entirely different workshee

M

mgonzalez

I right click on the cell/s that contains the formula I want copied and go
to an entriely new excel worksheet, right click on the cell - paste special.
A window appears with Paste as:
MS Excel 5.0 worksheet object, Picture, Bitmap, MS Excel 2007 binary format,
MS Excel 8. format, Biff5, SYLK, Dif, xml spreadsheet,HTML, unicode text,
text, csv, hyperlink. I've tried them all and the formula is not pasting to
the new worksheet. A zero appears and no formula.

question: is there any way to copy a formula and paste the formula into a
completely different excel worksheet.
 
G

Gord Dibben

Don't run two instances of Excel with a workbook in each.

Open both workbooks in a single instance.


Gord Dibben MS Excel MVP
 

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

No "Comments" in Paste Special 5
Paste Special Help (Excel 2003) 5
Copy absolute formulas 1
Can't copy formulas in a worksheet 7
Excel is pasting values, not formulas by default 3
Formulas are becoming text strings 2
Copy worksheet to new doc w/formulas not referencing previous doc 4
problem copying formula from one workbook to another 1

Top