In this Excel Tutorial I will show you how to Open and Create a Template in Excel 2010.
Templates are pre designed spreadsheets, formatted and often with formulas and they are ready to be used.
In our first example we will open an existing template.
Go to File tab and click new. In this Tab we can see Available Templates. Below, we can see for example Invoices, Calendars, Budgets and more different Templates.
In this example I will use of the Invoices template from Invoices Category. To do this we have to click Invoices (see previous image), Work orders (see below).
Than we have to select first Template - Work order (Blue Gradient design).
At the right corner we have an Download option and which we need to click.
Now, we can see the Template which we can modify and save it under a different name.
We can also create our own Template which we will be able to reuse in the future.
To do that we have to save document as a Template.
First create desired document than click File and select Save As.
From the save as type drop down box we choose Excel Template.
The Template is saved in the location where Excel stores document Templates (which you can change if you wish). I click Save.
Now, we are going to File tab and click new. If we will go to My templates - we can see that our Template Work order1 was added to Personal Templates.
This way you can create and add your Templates.
I hope this Excel Tutorial was useful.
Katie and Emil