Share via

EXCEL 2010 - Book1

Anonymous
2014-03-28T14:45:57+00:00

I have Microsoft Excel 2010 running under Windows8.

How do i amend the template to create a new version of Book1 - i want to amend certain of the number formats?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2014-03-28T15:28:17+00:00

    If you want to change the blank new workbook that is opened when you start Excel or press Ctrl+N, modify the blank workbook to suit your needs, then save it as a Microsoft Excel template named Book.xltx (this name is obligatory) in your Excel startup folder. By default, that is

    C:\Users<username>\AppData\Roaming\Microsoft\Excel\XLSTART

    AppData is a hidden folder, so you must show hidden files, folders and drives in Windows Explorer to see it.

    Also create a version of the workbook with just one worksheet, and save it as a template named Sheet.xltx in the same folder.

    It will then be used when you insert a new sheet into an existing workbook.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-03-28T17:16:53+00:00

    If you want to change the blank new workbook that is opened when you start Excel or press Ctrl+N, modify the blank workbook to suit your needs, then save it as a Microsoft Excel template named Book.xltx (this name is obligatory) in your Excel startup folder. By default, that is

    C:\Users<username>\AppData\Roaming\Microsoft\Excel\XLSTART

    AppData is a hidden folder, so you must show hidden files, folders and drives in Windows Explorer to see it.

    Also create a version of the workbook with just one worksheet, and save it as a template named Sheet.xltx in the same folder.

    It will then be used when you insert a new sheet into an existing workbook.

    Brilliant!  Thanks very much!

    0 comments
  2. Anonymous
    2014-03-28T15:22:24+00:00

    After amending custom formats, Save Book1 with a new name as a template file (xltx or xltm extension).

    Use this new template file in future.

    0 comments