Templates

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