Results 1 to 8 of 8
  1. #1
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Difference between sheet.xltx and book.xltx in Excel 2010

    if I st a book.xltx and a sheet.xltx, which one controls formatting? Do I need both? Can't I just have a book.xltx to always be the default format template?

    Regards,
    Chuck Billow
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  2. #2
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,078
    Thanks
    0
    Thanked 259 Times in 248 Posts
    A few times I've used a template to start a workbook. I found one way in Excel's Help:
    Templates are files that help you design interesting, compelling, and professional-looking workbooks. All the formatting is complete; you add what you want to them. Examples are budgets, lists, and reports. You can modify a document or existing template, and then save it as your very own custom template.
    Do any of the following:

    Create a new template based on a document
    Open the workbook that you want to create the new template from.
    Add, delete, or change any text, graphics, or formatting, and make any other changes that you want to appear in all new documents that you base on the template.
    On the File menu, click Save As.
    On the Format pop-up menu, click Excel Template (.xltx).
    In the Save As box, type the name that you want to use for the new template, and then click Save.
    Unless you select a different location, the template is saved in /Users/username/Library/Application Support/Microsoft/Office/User Templates/My Templates.
    On the File menu, click Close.
    Tip To organize templates, use the Finder to create a new folder in /Users/username/Library/Application Support/Microsoft/Office/User Templates/My Templates, and then save your template in the new folder.

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,639
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Yes you can. However the sheet.xltx is the template used when adding a new worksheet. You can preformat this the way you like and when a sheet is added to a workbook, it will be a copy of Sheet.xltx. If you create this template, make sure you save it with only one sheet.

    HTH,
    Maud

  4. #4
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts
    Berton, so then do you rely on a template *worksheet* as opposed to a book? Or do you rely totally on Excel's default formatting, or set it up each time as needed?

    Regards,
    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  5. #5
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts
    Ah, so then it IS the book.xltx that is the startup template. Is the sheet.xltx stored in the same folder as the book.xltx?

    Regards,
    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  6. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,639
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Yes, If you want it to define the format of the inserted sheet

  7. The Following User Says Thank You to Maudibe For This Useful Post:

    CWBillow (2014-12-05)

  8. #7
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,078
    Thanks
    0
    Thanked 259 Times in 248 Posts
    If I have any indication I might want the same format again I save as a named template but otherwise set up as needed.

  9. The Following User Says Thank You to Berton For This Useful Post:

    CWBillow (2014-12-05)

  10. #8
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts
    Thanks guys.
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

Posting Permissions

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