What Is An Excel Template File

Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More...Less

If you often apply the aforementioned layout or data in a workbook, save it as a template so you lot can utilise the template to create more workbooks instead of starting from scratch.

Y'all tin can use i of your own templates to create a new workbook, or y'all tin use one of the many predefined templates that you tin download from Microsoft Office Online.

Save a workbook as a template

If you lot're saving a workbook to a template for the first time, showtime past setting the default personal templates location :
1. Click File > Options.
2. Click Save, and then under Save workbooks, enter the path to the personal templates location in the Default personal templates location box.
  
  This path is typically: C:\Users\[UserName]\Documents\Custom Office Templates.
3. Click OK.
  
  One time this option is set, all custom templates you salve to the My Templates folder automatically announced under Personal on the New folio (File > New).
Open the workbook yous want to use equally a template.
Click File > Export.
Under Export, click Change File Type.
In the Workbook File Types box, double-click Template.
In the File proper name box, blazon the name you want to use for the template.
Click Save, and then close the template.

Create a workbook based on the template

With the template y'all created in a higher place, you can create a new workbook. This section tells you how to do that.

Note:Alternately, you can browse for various online templates in Excel and use them instead. For more information, see Download free, pre-built templates.

Click File > New.
Click Personal.
Double-click the template y'all just created.

Excel creates a new workbook that is based on your template.

Salve a workbook as a template

Open up the workbook that you want to apply as a template.
Click File, and so click Save As.
In the File name box, blazon the proper name that you want to utilise for the template.
In the Save every bit type box, click Excel Template, or click Excel Macro-Enabled Template if the workbook contains macros that you desire to make available in the template.
Click Save.

The template is automatically placed in the Templates folder to ensure that it volition be bachelor when you want to apply information technology to create a new workbook.

Tip:Yous can copy any Excel workbook into the Templates binder, and then yous can employ the workbook as a template without saving it in the template file format (.xltx or .xltm). In Windows Vista, the Templates binder is usually C:\Users\<your proper noun>\AppData\Roaming\Microsoft\Templates. In Microsoft Windows XP, the Templates folder is usually C:\Documents and Settings\<your proper name>\Application Data\Microsoft\Templates.

Utilise a template to create a new workbook

Click File and then click New.
Nether Available Templates, do one of the post-obit:
- To base the workbook on a recently used template, click Contempo Templates, and and then double-click the template that you want to utilise.
- To base the workbook on an installed template, click Sample templates and so double-click the template that you want to use.
- To base the workbook on a template that you lot created, click My templates, so on the Personal Templates tab, double-click the template that y'all want to use.
- To base the workbook on another workbook, click New from Existing, and and then double-click the workbook that you lot desire to use.

Tip:When you are connected to the Internet, you tin can also access templates that are bachelor from Office.com. Under Office.Com Templates, click a template category, and then under that category, double-click the template that you want to download. If the template that you desire to download has been supplied by a fellow member of the Microsoft Office.com Community, yous must click I accept to take the License Agreement for Community Templates Terms of Use before you can download that template.

Save a workbook as a template

Open the workbook that y'all want to utilize as a template.
Click the Microsoft Office Push button , and and then click Salve As.
In the File name box, type the name that you want to employ for the template.
In the Save as type box, click Excel Template, or click Excel Macro-Enabled Template if the workbook contains macros that you want to make available in the template.
Click Relieve.

The template is automatically placed in the Templates folder to ensure that it will be available when you desire to utilize it to create a new workbook.

Tip:You tin copy any Excel workbook into the Templates folder, then you tin utilize the workbook as a template without saving it in the template file format (.xltx or .xltm). In Windows Vista, the Templates folder is usually C:\Users\<your name>\AppData\Roaming\Microsoft\Templates. In Microsoft Windows XP, the Templates folder is usually C:\Documents and Settings\<your proper noun>\Application Data\Microsoft\Templates.

Use a template to create a new workbook

Click the Microsoft Office Push button , and then click New.
Under Templates, do one of the post-obit:
- To base of operations the workbook on a recently used template, click Bare and contempo, and then under Recently Used Templates, double-click the template that you lot desire to use.
- To base the workbook on an installed template, click Installed Templates, and then under Installed Templates, double-click the template that you want to use.
- To base the workbook on a template that you created, click My templates, so on the My Templates tab, double-click the template that you want to use.
- To base the workbook on another workbook, click New from Existing, and and then double-click the workbook that you want to utilise.

Tip:When you are connected to the Internet, y'all can also access templates that are bachelor from Office Online. Under Microsoft Part Online, click a template category, so nether that category, double-click the template that you lot want to download. If the template that y'all want to download has been supplied past a member of the Microsoft Role Online Community, you lot must click I accept to accept the License Agreement for Customs Templates Terms of Employ before you tin can download that template.

Need more than help?