How To Tell If An Excel File Was Created From Scratch Or A Template

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

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

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

Save a workbook as a template

If you're saving a workbook to a template for the commencement time, showtime by setting the default personal templates location :
1. Click File > Options.
2. Click Save, and and so under Salve 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.
  
  Once this pick is set, all custom templates you lot save to the My Templates folder automatically announced under Personal on the New page (File > New).
Open the workbook you lot desire to use as a template.
Click File > Export.
Under Export, click Modify File Type.
In the Workbook File Types box, double-click Template.
In the File name box, type the proper name you want to employ for the template.
Click Save, and then close the template.

Create a workbook based on the template

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

Notation:Alternately, you lot can browse for various online templates in Excel and use them instead. For more data, see Download free, 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.

Save a workbook as a template

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

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

Tip:You can copy any Excel workbook into the Templates folder, and then you 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 normally C:\Users\<your name>\AppData\Roaming\Microsoft\Templates. In Microsoft Windows XP, the Templates folder is usually C:\Documents and Settings\<your proper name>\Awarding Data\Microsoft\Templates.

Use a template to create a new workbook

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

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

Save a workbook every bit a template

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

The template is automatically placed in the Templates folder to ensure that information technology will exist bachelor when you desire to use it to create a new workbook.

Tip:You tin copy any Excel workbook into the Templates binder, then you lot tin can apply the workbook as a template without saving it in the template file format (.xltx or .xltm). In Windows Vista, the Templates binder 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.

Use a template to create a new workbook

Click the Microsoft Office Button , and then click New.
Under Templates, do one of the post-obit:
- To base the workbook on a recently used template, click Blank and recent, and then 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 so nether Installed Templates, double-click the template that yous want to use.
- To base the workbook on a template that you created, click My templates, and and then 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, so double-click the workbook that you want to use.

Tip:When you are connected to the Internet, yous can too admission templates that are available from Office Online. Under Microsoft Office Online, click a template category, and and then under that category, double-click the template that you lot desire to download. If the template that you lot want to download has been supplied by a member of the Microsoft Office Online Community, yous must click I accept to have the License Agreement for Community Templates Terms of Apply before you lot tin download that template.