98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses london - Templates - Excel and word
excel vba courses london - Templates - Excel and word
Resolved · Low Priority · Version Standard
Sarah has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Access Introduction course
Templates - Excel and word
My employer wants me to set up templates to standardize all our word and excell documents. How do I do This?
Thank you
RE: Templates - Excel and word
Hi Sarah
Thanks for your question.
In Excel, set up the spreadsheet with all the necessary labels, formatting and formulas in it, ready for whoever needs to use it to enter the relevant figures when they create a spreadsheet from the template.
When you go to save the file, instead of saving as a Microsoft Excel Workbook, change the file type to Template.
In Word, set up the document ready for someone to fill in the necessary parts/sections, with all the formatting, headers and footers etc all entered in. You may find it useful to use form fields in the document, depending on what people will be entering into it. Styles will be useful if the document will have lots of headings. Then instead of saving as a Microsoft Word Document, change the file type to Template.
I hope this helps.
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:New Normal WorksheetDo you want all your worksheets to confirm to a certain look? Then change the Defaults!!! |