How To Add A Template To Excel 2021 Mac

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

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

You lot can use 1 of your ain templates to create a new workbook, or you can use ane of the many predefined templates that you can download from Microsoft Office Online.

Salve a workbook as a template

If you're saving a workbook to a template for the starting time time, first by 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.
  
  In one case this option is set, all custom templates you relieve to the My Templates binder automatically appear nether Personal on the New folio (File > New).
Open the workbook you desire to apply equally a template.
Click File > Export.
Nether Export, click Change File Type.
In the Workbook File Types box, double-click Template.
In the File proper name box, type the name you lot want to use for the template.
Click Salve, and and so close the template.

Create a workbook based on the template

With the template you created above, you tin create a new workbook. This section tells you how to do that.

Annotation:Alternately, you can browse for various online templates in Excel and utilize 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.

Relieve a workbook equally a template

Open the workbook that you want to use equally a template.
Click File, and then click Save As.
In the File name box, type the name that y'all want to use 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 bachelor in the template.
Click Salve.

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

Tip:You tin 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 commonly 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 File and then click New.
Under Bachelor Templates, do one of the following:
- To base the workbook on a recently used template, click Contempo Templates, and then double-click the template that you want to utilize.
- To base the workbook on an installed template, click Sample templates and and so double-click the template that you want to use.
- To base the workbook on a template that you created, click My templates, and then on the Personal Templates tab, double-click the template that yous desire to use.
- To base the workbook on another workbook, click New from Existing, and then double-click the workbook that y'all desire to use.

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

Save a workbook as a template

Open the workbook that you want to use as a template.
Click the Microsoft Office Push button , and and then click Save As.
In the File name box, blazon the name that you want to utilise for the template.
In the Save as blazon box, click Excel Template, or click Excel Macro-Enabled Template if the workbook contains macros that yous want to brand available in the template.
Click Save.

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

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

Use a template to create a new workbook

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

Tip:When you are continued to the Internet, you tin can also admission templates that are available from Office Online. Under Microsoft Role Online, click a template category, and so nether that category, double-click the template that you want to download. If the template that you desire to download has been supplied by a member of the Microsoft Office Online Community, you must click I have to accept the License Agreement for Community Templates Terms of Utilize before you can download that template.