Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy formulas from one worksheet to an entirely different workshee
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy formulas from one worksheet to an entirely different workshee
Copy from the formula bar...
In article , mgonzalez wrote: question: is there any way to copy a formula and paste the formula into a completely different excel worksheet. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy formulas from one worksheet to an entirely different workshee
Don't run two instances of Excel with a workbook in each.
Open both workbooks in a single instance. Gord Dibben MS Excel MVP On Fri, 26 Dec 2008 09:03:01 -0800, mgonzalez wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Detailed worksheet value entered automatically in Summary workshee | Excel Discussion (Misc queries) | |||
rename worksheet based on contents of a cell in different workshee | Excel Discussion (Misc queries) | |||
Linking Special Formats from One Worksheet to a Different Workshee | Excel Discussion (Misc queries) | |||
total two cells from one worksheet to one cell in another workshee | Excel Discussion (Misc queries) | |||
Excel Macro does not Replace text in formulas for several workshee | New Users to Excel |