Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Workbook specific template
I regularly need to insert new worksheets into a workbook, based on the
format of previous sheets. I do this by inserting a new blank worksheet, then copying the format from a previous worksheet , before entering data. Can a workbook specific template be set up that will automatically insert a ready formatted worksheet to that workbook only ? Changing the workbook xlt. or sheet.xlt changes the workbook/sheet for ALL other workbooks as well, which I dont want ? Any suggestions please? |
#2
|
|||
|
|||
An alternative.
Just ctrl-drag the worksheet tab to a new location. This copies the existing worksheet--format and values. Then clean up the stuff you don't want. But I think I'd keep a blank (formatted only) worksheet in the workbook (maybe hide it to keep it out of the way until I need it), then use that for the copy. (Unhide, copy, and hide the original.) Graham wrote: I regularly need to insert new worksheets into a workbook, based on the format of previous sheets. I do this by inserting a new blank worksheet, then copying the format from a previous worksheet , before entering data. Can a workbook specific template be set up that will automatically insert a ready formatted worksheet to that workbook only ? Changing the workbook xlt. or sheet.xlt changes the workbook/sheet for ALL other workbooks as well, which I dont want ? Any suggestions please? -- Dave Peterson |
#3
|
|||
|
|||
Many Thanks-That will be easier than copy/paste all the time! And hiding a
spare sheet will prevent someone filling in the last "template" copy "Dave Peterson" wrote: An alternative. Just ctrl-drag the worksheet tab to a new location. This copies the existing worksheet--format and values. Then clean up the stuff you don't want. But I think I'd keep a blank (formatted only) worksheet in the workbook (maybe hide it to keep it out of the way until I need it), then use that for the copy. (Unhide, copy, and hide the original.) Graham wrote: I regularly need to insert new worksheets into a workbook, based on the format of previous sheets. I do this by inserting a new blank worksheet, then copying the format from a previous worksheet , before entering data. Can a workbook specific template be set up that will automatically insert a ready formatted worksheet to that workbook only ? Changing the workbook xlt. or sheet.xlt changes the workbook/sheet for ALL other workbooks as well, which I dont want ? Any suggestions please? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I change an excel template into a "workbook" | Excel Discussion (Misc queries) | |||
Master Workbook used as my template? | New Users to Excel | |||
Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
How to open a workbook with a specific worksheet displayed by defa | New Users to Excel |