Templates allow you to create blank sheets and blank workbooks that have customized formats as well as customized Page Setup settings, including headers and footers. A template is a special Excel file type that when opened through Excel, creates a normal sheet or a normal file based on the template file settings.

If you open a template file directly from a folder it will open as a template file and allow you to edit it and save it.


Instead of creating an Excel workbook from scratch, you can create a workbook based on a template. There are many free templates available, waiting to be used.

Existing Templates


To create a workbook based on an existing template, execute the following steps.

1. On the File tab, click New.

2. Use the search box to search for online templates or click a template from one of the Office templates.

Screenshot (73).png

3. Click Create to download the template.

Excel creates the workbook Home inventory1.xlsx based on this template.

Create a Template


If you create your own template, you can safely store it in the Templates folder. As a result, you can create new workbooks based on this template without worrying that you overwrite the original file.

To create a template, execute the following steps.

1. Create a workbook.

2. On the File tab, click Save As.

3. Click Browse.

4. Enter a file name.

5. Select Excel Template (*.xltx) from the drop-down list.

Excel automatically activates the Templates folder. Notice the location of the Templates folder on your computer. It's usually located here:

C:\Users\<username>\Documents\Custom Office Templates

Screenshot (74).png