Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to copy worksheet into template?
I apologize, surely this has been asked before, but I can't find it anywhere,
let alone find an answer. (Excel 2003, WinXP Pro) I have a template open in edit mode, intending to add a worksheet that I wanted to just copy over from another Excel file. Is there a reason the template doesn't show up in the "To Book" list of the move/copy? Also because Excel doesn't support separate windows (at least not that I know of) I can't just drag it over. I can of course copy the content of the worksheet, insert a new worksheet in the template, and paste---but this doesn't bring over the row and column height or the Word object, and formatting all this would take a considerable amount of time. Is there an easier way? -- Fox Cole |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to copy worksheet into template?
You mean you have the actual template.xlt open?
Strange it does not show up in the "To Book" list. Does on my Excel 2003. But.............................. Excel will support separate windows. WindowNew Window. WindowArrangeVertical Gord Dibben MS Excel MVP On Tue, 2 Oct 2007 08:25:02 -0700, foxcole wrote: I apologize, surely this has been asked before, but I can't find it anywhere, let alone find an answer. (Excel 2003, WinXP Pro) I have a template open in edit mode, intending to add a worksheet that I wanted to just copy over from another Excel file. Is there a reason the template doesn't show up in the "To Book" list of the move/copy? Also because Excel doesn't support separate windows (at least not that I know of) I can't just drag it over. I can of course copy the content of the worksheet, insert a new worksheet in the template, and paste---but this doesn't bring over the row and column height or the Word object, and formatting all this would take a considerable amount of time. Is there an easier way? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to copy worksheet into template?
This is a guess, and untested: Try saving the template as a workbook
(.xls file), move the worksheet to it, then resave it as a template. Mark Lincoln On Oct 2, 11:25 am, foxcole wrote: I apologize, surely this has been asked before, but I can't find it anywhere, let alone find an answer. (Excel 2003, WinXP Pro) I have a template open in edit mode, intending to add a worksheet that I wanted to just copy over from another Excel file. Is there a reason the template doesn't show up in the "To Book" list of the move/copy? Also because Excel doesn't support separate windows (at least not that I know of) I can't just drag it over. I can of course copy the content of the worksheet, insert a new worksheet in the template, and paste---but this doesn't bring over the row and column height or the Word object, and formatting all this would take a considerable amount of time. Is there an easier way? -- Fox Cole |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to copy worksheet into template?
"Mark Lincoln" wrote:
This is a guess, and untested: Try saving the template as a workbook (.xls file), move the worksheet to it, then resave it as a template. Mark Lincoln Er... yep, that did of course work just fine! Too simple! Tooooooo obvious! So of course I didn't see it. :D I chalk it up to sleep deprivation. OF course, this solves the problem though not the question, but it also renders the question null. Thank you, Mark. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Filterd Data from worksheet to another workbook template | Excel Discussion (Misc queries) | |||
Template question - can I replace the default "worksheet" template | Excel Discussion (Misc queries) | |||
Need copy of NFL 2004 template | Excel Discussion (Misc queries) | |||
How do I copy protect an Excel template | Excel Discussion (Misc queries) | |||
How do I copy a template in Excel? | Excel Worksheet Functions |