#1   Report Post  
Old December 29th 05, 04:50 PM posted to microsoft.public.excel.misc
Sam
 
Posts: n/a
Default Template

I am having difficulty in creating a template. The 'help' info doesn't.
What are the first steps to creating a template?

  #2   Report Post  
Old December 29th 05, 11:02 PM posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default 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?


  #3   Report Post  
Old December 30th 05, 03:37 AM posted to microsoft.public.excel.misc
RagDyer
 
Posts: n/a
Default 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?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting Filtered RC cell information into other worksheets Dennis Excel Discussion (Misc queries) 10 July 30th 05 01:54 AM
Need One Excel Template to copy to TWO Databases gildo4realdo Excel Discussion (Misc queries) 0 July 29th 05 03:57 PM
How do you open a template at startup? James Kendall Excel Discussion (Misc queries) 7 July 26th 05 07:33 PM
"Can not download excel template" JF Sly Excel Discussion (Misc queries) 0 April 19th 05 06:36 PM
Excel template to load automatically as the default template? David Excel Discussion (Misc queries) 1 March 21st 05 01:24 PM


All times are GMT +1. The time now is 12:02 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017