How To Use Template In MS Excel spreadsheet

Excel template is also a workbook, the only different is that it can be as a template or module to create other similar workbooks. There are many free excel templates in the internet or you can create your own excel template.

1. Create a workbook based on existing templates

If you want to create one workbook based on an existing template, just following the below steps:

Step 1#  click “File” Tab

excel template 1

Step 2# Then clicking “New” menu, you will see lots of templates, such as: Blank workbook, Academic Calendar, Student calendar…etc.

excel template 2

Step 3# choose one sample category, such as “Academic calendar”, then click “create” button.

excel template 3

Step 4# one new workbook created.

excel template 4

2. Create a new template

The below steps will guide you how to create your own template.

Step 1# create one black workbook or create one workbook based on existing templates.

Step 2# make some changes that you want to appear in all new workbook that you base on the template.

Step 3# On “File” Tab, click “Save As” , then input one file name, select “Excel Template(*.xltx)” As file type.

excel template 5

Step 4# click “Save” button.

3. Use your own template

To create one workbook based on your own template, just following the below steps:

Step1# Go To “File” Tab, click “New” menu

Step2# click “PERSONAL” template, then select the template that you want to use

excel template 6


Leave a Reply