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

 

Related Posts

Free Wedding Guest List Templates

This article will show you some free wedding guest list templates for google sheet and Microsoft Excel Spreadsheet and will also provide some explanations about the features or important functional features of these templates. When you are using these templates, ...

Invoice template with finance charge (gray) In MS Excel

This invoice template with finance charge (gray) for excel will calculate line item total automatically, you need to enter descriptions, quantity and amount. And when charging interest on unpaid customer account balances, use this invoice template with finance charge to ...

Invoice template with finance charge In MS Excel

This finance invoice template for excel will calculate line item total automatically, you need to enter customer and shipping details, descriptions and amount. And it is very easy to customize and use. And also is a very simple invoice finance ...

Billing invoice template In MS Excel

This billing invoice template for excel will calculate line item total. And payment details can be find in another worksheet named as “Company Setup”. If you are looking for a professional billing invoice template for MS excel, this billing invoice ...

Invoice template that calculates total In MS Excel

This invoice template for excel will calculate line item Amount, sales tax, and Less Deposit Received to get invoice Total value. And it is very easy to customize and use. And also is a very simple invoice template for your ...

Sidebar