Can I Create Templates In Excel

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

If you often use the same layout or data in a workbook, save information technology as a template so you can use the template to create more workbooks instead of starting from scratch.

You can use one of your own templates to create a new workbook, or you lot can use one of the many predefined templates that y'all can download from Microsoft Role Online.

Relieve a workbook as a template

If you're saving a workbook to a template for the first time, starting time by setting the default personal templates location :
1. Click File > Options.
2. Click Save, and so 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 Role Templates.
3. Click OK.
  
  Once this pick is ready, all custom templates you save to the My Templates folder automatically announced nether Personal on the New page (File > New).
Open the workbook you want to utilise as a template.
Click File > Export.
Under Consign, click Change File Blazon.
In the Workbook File Types box, double-click Template.
In the File name box, type 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 you created to a higher place, you lot can create a new workbook. This section tells you lot how to exercise that.

Note:Alternately, y'all tin browse for various online templates in Excel and use them instead. For more information, encounter Download gratis, pre-built templates.

Click File > New.
Click Personal.
Double-click the template you just created.

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

Relieve a workbook as a template

Open up the workbook that you desire to apply equally a template.
Click File, and so click Save As.
In the File name box, blazon the proper noun that you want to apply 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 desire to brand available in the template.
Click Save.

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

Tip:You tin re-create any Excel workbook into the Templates folder, then you can employ the workbook every bit a template without saving information technology in the template file format (.xltx or .xltm). In Windows Vista, the Templates folder is ordinarily C:\Users\<your name>\AppData\Roaming\Microsoft\Templates. In Microsoft Windows XP, the Templates binder is unremarkably C:\Documents and Settings\<your name>\Application Information\Microsoft\Templates.

Utilise a template to create a new workbook

Click File and so click New.
Nether Available Templates, practice one of the following:
- To base the workbook on a recently used template, click Contempo Templates, and so double-click the template that you desire to use.
- To base the workbook on an installed template, click Sample templates and then double-click the template that you want to utilize.
- To base of operations the workbook on a template that you created, click My templates, and and so on the Personal Templates tab, double-click the template that you want to apply.
- To base of operations the workbook on some other workbook, click New from Existing, and and then double-click the workbook that you want to use.

Tip:When you are connected to the Internet, you lot can as well access templates that are available from Role.com. Under Office.Com Templates, click a template category, and so under that category, double-click the template that you want to download. If the template that you desire to download has been supplied past a member of the Microsoft Role.com Community, you lot must click I have 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 you want to use as a template.
Click the Microsoft Function Button , and and then click Save As.
In the File proper name box, type the name that you want to use for the template.
In the Save as blazon 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 Save.

The template is automatically placed in the Templates binder to ensure that information technology will be available when you lot want to use it to create a new workbook.

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

Use a template to create a new workbook

Click the Microsoft Office Button , and and so click New.
Under Templates, exercise one of the following:
- To base of operations the workbook on a recently used template, click Bare and recent, and and so nether Recently Used Templates, double-click the template that you want to apply.
- To base the workbook on an installed template, click Installed Templates, and and so under Installed Templates, double-click the template that you want to use.
- To base of operations the workbook on a template that you created, click My templates, and then on the My Templates tab, double-click the template that yous want to use.
- To base the workbook on another workbook, click New from Existing, and so double-click the workbook that you desire to use.

Tip:When y'all are continued to the Internet, you can also admission templates that are available from Office Online. Under Microsoft Function Online, click a template category, and then nether that category, double-click the template that you lot desire to download. If the template that y'all want to download has been supplied by a member of the Microsoft Office Online Community, you must click I take to accept the License Agreement for Customs Templates Terms of Utilise before you tin can download that template.

Need more assist?