Excel - How to create Templates in Excel 2010

In my last tutorial I talked about "how to use templates" in Microsoft Excel. Also I explained what is a template and why should we use templates. To recollect I would like to mention again that - templates in Microsoft Excel can be used to eliminate efforts for repetitive work and we should use templates to increase productivity of our excel work.

In this tutorial I am going to show how to create an excel template. Once we have an excel work book ready to use as template, we have to save it as type "Excel Template (*.xltx)" or "Excel Macro-Enabled Template (*.xltm)". "Excel Macro-Enabled Template" is for a template having macros defined in it and for simple templates the option "Excel Template" can be used.

Check the video tutorial for details about how to create a Template in Microsoft Excel. Use template, save time, be productive.

[emmadkareem]

Thank you for the video. It would be helpful if you tell the audience how is this template different from a regular excel workbook? What value do you get when you do this? This is important.

[TechTutorialVideo]

By default excel/ office applications will store templates under:


As it is saving templates under a specific user, only that specific user will be able to access it. So if you want to save a template so that all users of a computer can access it, you have to save template in a common place which can be access by all user. e.g. a folder created under C:\ drive like C:\AllUserTemplate. Check my other message as continuation ...

[TechTutorialVideo]

Now the question is how to change the template location to a folder you want. Surprisingly that can be done only from Word. So follow this:

Close Excel
Open Word
Go to the file menu
Click Options
Click Advanced
Scroll down to the section General
Click the button File Locations
Click the Template entry
Click the Change button
Search and click on the folder you like
Click Ok, Ok, Ok until every window is closed

Let me know if it works!! Thanks for checking my tutorial!!