Home / MS-Excel / General Formatting

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.

Templates

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.