98.8% 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 » Templates for a worksheet
Templates for a worksheet
Resolved · Low Priority · Version 365
Mark has attended:
PowerPoint Introduction course
Excel Introduction course
Templates for a worksheet
Is there a way to define the lay out of a worksheet before it is opened for the first time?
RE: Templates for a worksheet
Hello Mark,
Thank you for your question to the forum.
In Excel, you can create a template so that when you open a new file for the first time it always opens the original document. Here's how to do it:
1. Set up your spreadsheet to the content and structure you want for your template. This can include standard colours and formatting for title/headings etc. Any formulas can also be included.
2. Now go to FILE > SAVE AS > BROWSE and in the 'Save As' dialog box, go to the 'Save as Type' drop down. Select Excel Template from the list. Notice the file path at the top shows where it will be saved ie. ending in Document > Custom Office Templates. This is really useful to navigate to this location if you ever need to edit an existing template. Click Save.
3. When you are ready to use a template, open Excel and go to FILE > NEW. You will see 2 menu options OFFICE and PERSONAL. Click on PERSONAL to reveal your template
4. Use the template to enter whatever data is required and then click SAVE. This will automatically convert to SAVE AS where the Save as Type is set to a standard Excel Workbook. Save this to your preferred location on your device.
I hope this helps and please let us know if you need any more support
Kind regards
Martin
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:Trace Dependents / Precedents without the blue arrowsRather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula. |