DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Use Template in Microsoft Excel Office 365 – With Examples!!!

In this guide, we will explain how to Use Template in Excel Office 365 with clear-cut screenshots. The template or module is used to create similar workbooks. There are plenty of free templates available on the internet. You can also create your own template. Let’s get into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Create a Workbook using Existing Templates:

To create a workbook using Existing templates, just follow the below steps.

File Tab
File Tab

  • Then, you need to click the New option from the menu.

Select the New option
Select the New option

  • It will show you lots of templates such as Blank workbook , Academic Calendar , Student calendar , and so on.
  • Now, you need to select one sample category, such as “Academic Calendar”.
  • Then, hit the Create button.

Click Create option
Click Create option

  • Finally, you will see the new workbook that has been created.

Created Calendar
Created Calendar

Steps to Create a New Template:

If you want to create your own template in Excel, then follow the below instructions.

  • Here, we are going to see how to create one workbook based on existing templates.
  • You need to make some changes that you want to appear in all the new workbook.
  • On the File tab, select the Save As option.
  • Then, you need to input one file name and select the Excel Template(*.xltx) as file type.

Click the Save button
Click the Save button

  • At last, click the save button.

In this way, you can create a new template in Excel.

Use your Own Template:

You can create one workbook based on your own template. To do this, follow the below steps.

  • Go to the File Tab , select the New option from the menu.
  • Then, you need to click the PERSONAL template, then you need to select the template that you want to use.

Click Personal Option
Click Personal Option

  • It will display many templates for your use that are created already.

Templates
Templates

Bottom-Line:

In this guide, you can easily understand the steps to Use Template in Excel Office 365 with clear-cut screenshots. Drop your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!

Read Also:

Top comments (0)