Template
I am having difficulty in creating a template. The 'help' info doesn't.
What are the first steps to creating a template? |
Template
Sam
Start a new workbook or use one you have already created. Set it up as you wish. FileSave AsFile TypeMS Excel Template(*.xlt) Gord Dibben Excel MVP On Thu, 29 Dec 2005 07:50:04 -0800, Sam wrote: I am having difficulty in creating a template. The 'help' info doesn't. What are the first steps to creating a template? |
Template
It might pay to mention that the template (copy) can be accessed by clicking
<File <New And in the newer versions, <(General) Templates in the task pane on the right. Click on the template name. This opens a *copy* of the template, with a "1" appended to the template name in the title bar, while the original remains protected in the templates folder. You can have as many copies simultaneously open as you wish, each with it's own ID number appended to the name. This copy can (should) be renamed and saved in the appropriate file after it has been utilized.. When it becomes necessary to update and/or revise the original, just open a copy as usual, make your revisions, and when ready for saving, duplicate what Gord instructed you to do the first time ... HOWEVER ... remove the ID number *first*, so that the copy has the exact name of the original template, replacing the original in the templates folder. You'll then be asked if you're sure that you want to replace the original, to which you naturally answer "Yes". -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Gord Dibben" wrote in message ... Sam Start a new workbook or use one you have already created. Set it up as you wish. FileSave AsFile TypeMS Excel Template(*.xlt) Gord Dibben Excel MVP On Thu, 29 Dec 2005 07:50:04 -0800, Sam wrote: I am having difficulty in creating a template. The 'help' info doesn't. What are the first steps to creating a template? |
All times are GMT +1. The time now is 09:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com