Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    May 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Worksheet Template (2000)

    When I open a new Excel workbook using a custom template, it opens one worksheet as per the template. When I add a worksheet, however, the new worksheet is just the standard, blank worksheet - not the custom worksheet. How can I make new sheets in the book open like the original custom one?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Worksheet Template (2000)

    If this is a custom template, I can't think of anything better than
    <UL><LI>Immediately after creating the new workbook, duplicate the worksheet as many times as needed, or
    <LI>Create another new workbook based on the template, and moving the worksheet from the new workbook to the one you already created; this can be done at any time.[/list]If you want to use the template as default new worksheet for all your workbooks, make a copy, rename the copy to Sheet.xlt and store it in your XLSTART folder. It will be used as model when you select Insert | Worksheet. Similarly, if you want to use it as model for new workboks, make a copy, rename the copy to Book.xlt and store it in XLSTART.

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Excel Worksheet Template (2000)

    If your template is saved in your Templates folder, you can Insert a copy of the template anytime you want by right-clicking on a sheet tab and select Insert. You should be presented with a list of all files in your template folder from which you can select the one you wish to use.

    Andrew C

  4. #4
    New Lounger
    Join Date
    May 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Worksheet Template (2000)

    Thanks so much. That is exactly what I need. I wonder why the Insert menu command doesn't give you a similar choice? Ahh - Microsoft moves in mysterious ways.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •