How To Save A Spreadsheet Template

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

If you often use the same layout or information in a workbook, save it every bit a template so you lot tin utilize the template to create more workbooks instead of starting from scratch.

You lot can utilize one of your own templates to create a new workbook, or you can apply one of the many predefined templates that you can download from Microsoft Office Online.

Save a workbook as a template

If you're saving a workbook to a template for the kickoff time, start by setting the default personal templates location :
1. Click File > Options.
2. Click Save, and so nether Salvage 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 Part Templates.
3. Click OK.
  
  Once this option is set, all custom templates y'all save to the My Templates folder automatically appear nether Personal on the New page (File > New).
Open up the workbook you want to utilise equally a template.
Click File > Export.
Under Consign, click Change File Type.
In the Workbook File Types box, double-click Template.
In the File name box, type the proper noun you want to use for the template.
Click Save, and then close the template.

Create a workbook based on the template

With the template yous created above, you can create a new workbook. This department tells y'all how to do that.

Note:Alternately, you lot can browse for various online templates in Excel and use them instead. For more than information, run into Download gratuitous, 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.

Salve a workbook as a template

Open up the workbook that you want to use as a template.
Click File, and and then click Save As.
In the File name box, type 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 you want to make available in the template.
Click Save.

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

Tip:Y'all can copy any Excel workbook into the Templates folder, and so y'all can employ the workbook as a template without saving information technology in the template file format (.xltx or .xltm). In Windows Vista, the Templates binder is usually C:\Users\<your proper name>\AppData\Roaming\Microsoft\Templates. In Microsoft Windows XP, the Templates folder is usually C:\Documents and Settings\<your proper name>\Application Information\Microsoft\Templates.

Use a template to create a new workbook

Click File and and then click New.
Under Available Templates, do i 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 employ.
- 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 created, click My templates, then on the Personal Templates tab, double-click the template that you want to use.
- To base the workbook on another workbook, click New from Existing, and so double-click the workbook that you want to employ.

Tip:When you are continued to the Cyberspace, you can also access templates that are available from Part.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 y'all want to download has been supplied by a fellow member of the Microsoft Office.com Community, you must click I accept to take the License Agreement for Community Templates Terms of Use before you can download that template.

Save a workbook equally a template

Open the workbook that yous want to use every bit a template.
Click the Microsoft Office Button , and so click Save As.
In the File name box, type the name that you want to apply for the template.
In the Salve as blazon 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 Save.

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

Tip:You can copy any Excel workbook into the Templates binder, so you can utilize the workbook equally a template without saving it 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 folder is usually C:\Documents and Settings\<your name>\Application Data\Microsoft\Templates.

Utilize a template to create a new workbook

Click the Microsoft Role Push , and so click New.
Under Templates, do one of the following:
- To base the workbook on a recently used template, click Blank and recent, so under Recently Used Templates, double-click the template that you lot want 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, and then on the My Templates tab, double-click the template that you want to utilise.
- To base the workbook on another workbook, click New from Existing, and so double-click the workbook that y'all want to use.

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