Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste, Paste Special
I've got a worksheet in one workbook that I want to paste into a blank
worksheet in another. I've tried selecting the whole worksheet, then Copy, etc, tried selecting only the particular cells I want, then Copy, etc, I've tried Paste, Paste Special, All, Formats, Formulas, the lot. But it still won't paste all the formulas nor all the formats in, only some, as far as I can see. I've got both worksheets open in the 'same' Excel, ie I haven't got Excel open twice (it won't do it at all then). Any answers? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste, Paste Special
Open both workbooks (make sure you have backups in case something goes
wrong) Use Window | Arrange | Tiled so you can see both Hold down the CTRL key and drag the tab of the source worksheet to the tab line of the target book; Release mouse button Now the second book has an exact copy of the sheet from the first book best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "robzrob" wrote in message ... I've got a worksheet in one workbook that I want to paste into a blank worksheet in another. I've tried selecting the whole worksheet, then Copy, etc, tried selecting only the particular cells I want, then Copy, etc, I've tried Paste, Paste Special, All, Formats, Formulas, the lot. But it still won't paste all the formulas nor all the formats in, only some, as far as I can see. I've got both worksheets open in the 'same' Excel, ie I haven't got Excel open twice (it won't do it at all then). Any answers? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste, Paste Special
On Jul 15, 8:33*pm, "Bernard Liengme"
wrote: Open both workbooks (make sure you have backups in case something goes wrong) Use Window | Arrange | Tiled *so you can see both Hold down the CTRL key and drag the tab of the source worksheet to the tab line of the target book; Release mouse button Now the second book has an exact copy of the sheet from the first book best wishes -- Bernard Liengme Microsoft Excel MVPhttp://people.stfx.ca/bliengme "robzrob" wrote in message ... I've got a worksheet in one workbook that I want to paste into a blank worksheet in another. *I've tried selecting the whole worksheet, then Copy, etc, tried selecting only the particular cells I want, then Copy, etc, I've tried Paste, Paste Special, All, Formats, Formulas, the lot. *But it still won't paste all the formulas nor all the formats in, only some, as far as I can see. *I've got both worksheets open in the 'same' Excel, ie I haven't got Excel open twice (it won't do it at all then). *Any answers?- Hide quoted text - - Show quoted text - Hello Bernard Thank you very much - I was giving up hope! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions |