RE: Templates
Hello Hayley
Thank you for your question
To create a worksheet template:
Create a new Excel workbook containing one worksheet
One the worksheet specify all required settings
Go to File>Save As
In the Save as type box, select Template
In the Save in box, select the folder you wish to store your template in.
This link provides details on what the template is with a sample template containing details on how it was created:
http://office.microsoft.com/en-us/excel/HA010548141033.aspx
If this resolves your question, please mark it as resolved. If not, please reply with more information.
Kind regards
Cress