Thread: template
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default template

Kim

To create a Template...............

Open a new workbook........customize as you wish.

FileSave AsFile TypeExcel Template(*.xlt)

Type a name for it......do not add the .xlt extension.......Excel will do that.

Close the workbook.

FileNew...TemplatesOn My Computer. Double-click on the Template you just
saved.

A workbook based on the Template will open.

The Template itself does not open.

Do your work on the new workbook and save as regular workbook.

The Template will still be in your Templates folder ready for next time.

No changes have been made to the Template.


Gord Dibben MS Excel MVP


On Wed, 18 Apr 2007 12:26:37 -0700, Kim Gerring
wrote:

If I save a template how do I use it without losing it.
If I use it to fill in blanks and need to save it. How do I know the
template will stay in its file and not change?
Kim