This article was co-authored by How.com.vn Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. How.com.vn's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards.
This article has been viewed 5,068 times.
This How.com.vn teaches you how to save an Excel workbook as a custom template, using a computer. This way, you can import and use your custom templates to create and jumpstart other worksheets.
Steps
Using Excel 2010 or 2015
Open the Excel workbook you want to save as a template. Find the workbook you want to turn into a template on your computer, and double-click on its icon to open the spreadsheet.- Alternatively, you can open a blank workbook, and create your template from scratch.
Click the File tab. This button is in the upper-left corner of your screen. It will open your File options on a menu.
Click Save As on the File menu. This option will allow you to save this file in a different format than the standard Excel Workbook (.xlsx) format.- On Mac, you can just click the Save As Template option on the File menu.
Click the drop-down menu next to "Save as type." This will open a drop-down list of all the formats you can save your file as.- On Mac, this option may be labeled as "File Format."
Select Excel Template (*.xltx) on the drop-down list. This will save your workbook as a template, and allow you to import it later into other spreadsheet workbooks.- If your workbook contains macros, select Excel Macro-Enabled Template (*.xltm) here.
Select a saving location. Click the folder where you want to save your template.
Click the Save button. This will turn your workbook into a template, and save it to the selected destination.Advertisement
Using Excel 2013 or 2016
Open the Excel workbook you want to convert to a template. Find the workbook you want to save as a template on your computer, and double-click on its icon to open the spreadsheet.
Click the File tab. This button is in the upper-left corner of your screen. It will open your File options on a menu.
Click Options on the File menu. This will open your Excel options in a new pop-up window.
Click the Save tab on the left navigation panel. This option is listed between Proofing and Language on the left-hand side of the Excel Options window.
Set a default saving location for templates. Your template will be saved to this location later.- Scroll down to the "Save workbooks" section.
- Click the filepath field next to "Default personal templates location."
- Enter the filepath of the folder where you want to save your templates.
- Click the OK button to save it.
Click the File tab on the top-left. It will open your File menu.
Click Export on the File menu.
Click the Change File Type button. This will allow you to save your workbook in a different format.
Double-click Template in the Workbook File Types. This way, your file will be saved as a template, and can be used in a different workbook later.
Click the Save button. This will save your template to your default personal templates location.Advertisement
Expert Q&A
About this article
1. Open the workbook you want to use as template.
2. Click the File menu.
3. Click Save As or Export.
4. Change the file type to Excel Template or Template.
5. Click Save.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
