Create a Template in Excel – Custom Template

Creating a Template in Excel

To create a new template in Excel, follow the steps below. In this example, we will be creating the structure for a mortgage calculator.

File –> Blank Worksheet

template in excel

We are going to create the following the following Mortgage Calculator template.

Review this tutorial for creating a Mortgage Calculator

You can download the attached file as well.

Mortgage Calculator – Download FIle

template in excel

Click File –> Save As Excel Template (*.xltx)

template in excel

Excel automatically creates a New Folder in your Documents Folder called “Custom Office Templates

template in excel

You will find that the Mortgage Calculator Template is now listed in the folder.

template in excel

When you go to File Personal, you will now see the Mortgage Calculator template as an option.

template in excel

Was this article helpful?

Related Articles

Leave a Reply