What are Templates in Excel 2003
Templates are predesigned and formatted spreadsheets, the provide consistency of layout's structure and save time and repetition of work. Frequently when working with spreadsheets you want to use the same layout or design. You can re-create the design every time you want to use it or you can create a spreadsheet to use as a pattern. The spreadsheet pattern is called a template. Templates can be produced that include these elements: formulus, formatting information, marcos, headers and footers, layouts, styles, text and graphics.
A template is produced by creating a spreadsheet that contains all the elements you want, and then saving it as an .XLT file.
Templates are stored with the extension .XLT and when they are accessed to create a new sheet, a copy of the original is made. The original template is left untouched ready for further use.
In this tutorial:
- How to Create Templates?
- Working with Workbook Templates
- Understanding Custom Excel Templates
- Creating a Default Workbook Template
- Changing Default Print Settings Using a Template
- Creating Custom Templates
- Ideas for creating Templates
- Learn About Templates Style
- Locking Formula Cells in a Template File