Templates (strictly notes)

Location: http://www.mvps.org/dmcritchie/excel/template.htm Home page: http://www.mvps.org/davemcritchie/excel/excel.htm [View without Frames]

Templates (.XLT)

*** PARTS OF THIS SECTION MAY NOT BE CORRECT -- IT IS BEING WORKED ON ****

Actually probably won't be working on a templates section. Chip Pearson (see home page for a link) was gathering comments on creating a collection of templates on his site, in addition to his own. So I would expect that he would probably also create information on on everything there is to know about templates.

There are so many templates on the web that a listing of them might be better, except for one thing and that is that a lot of the good stuff would be material to go with published material and the descriptions are probably also copyrighted so you could hardly use your own words to describe something unless you have actually used it.

Some examples:

How can I make headers and footers default to none whenever I create a new worksheet? ( Posted November 7, 1996) To do this you need to make two templates and store them in your startup directory. (see article for details).
Changing Excel's Default Settings similar information covered in more detail in PC Magazine.
download files homework examples from a previous semester.
Occurrence Reporting and Processing System (ORPS) analysis software
Accounting Forms [http://accounting.ucdavis.edu/docs/forms/forms.htm].
Dispersion Pattern Analysis [http://indecol.mtroyal.ab.ca/biol1210/disp.htm].
Academic Affairs Shared Forms Server [http://www.humboldt.edu/~oaa/oaaforms.html]
Internet Software Guide for Engineers
Accounts Payable Office -- Instructions for completing the Non-PO Voucher and Invoice Form [--http://www.100folhas.pt/software/excel.html--] excel, visual basic, spreadsheet, applications, excel programming, microsoft, scientific, knowledge base, support information, add-ins, download, software, freeware, shareware, demos, tips, newsgroups, excel macros, programming, visual basic for applications, source code, vba, windows, advanced macros, developer, tutorial, advanced, files, archive, professional, code, faq, examples, worksheet, formulas, workbook, cells, polynomials, mathematics, linear, excel, systems, real, matrix, science, statistics, tools, analysis, education, packages, templates, simulation, help, applications, books, sheets, modules, microsoft excel, excel 97, office, visual, language, xls, spreadsheets, excel
Templates includes a template for a class roster. (David A Sykes)

Need information on having multiple .XLT files.
On my system c:/MSOffice/Templates/Spreadsheet Solutions
On my system c:/WINNT/Profiles/Administrator/Desktop/...

Apparently you can set up a book.xlt template for new books, and further refine it with a sheet.xlt template for sheets added to books. [want to find this documentation] /msoffice/office/xlstart

A template file (book.xlt) can be created in your XLSTART folder to set up your default Headers and Footers, Margins, # of sheets, gridline (color) etc. for all new blank workbooks, and new sheets.

Toolbars, template information formerly was on the Toolbars page.

You are one of many distinguished visitors who have visited my site here or in a previous location since this page was created on January 18, 20002, by removal from Toolbars page.

Visit [my Excel home page] [Index page] [Excel Onsite Search] [top of this page]

Please send your comments concerning this web page to: David McRitchie mailto:DMcRitchie@msn.com.

Templates (strictly notes)

Templates (.XLT)

Related