Using Templates

Templates for Microsoft Excel let you create spreadsheets quickly. Use Excel templates to also ensure a consistent design throughout.


In Excel 2007, you have many templates that can save you a lot of time. A template is a predesigned spreadsheet you can use to create new spreadsheets with the same formatting and predefined formulas. With templates, you don't need to know how to do the math, or even how to write formulas—these are already integrated into the spreadsheet.

In this lesson, you will learn how to create a new workbook with a template, as well as basic information about how templates work in Excel 2007.


Excel allows you to create a new workbook using a template, which is a predesigned spreadsheet. Several templates are preloaded in Excel, and others are located on

To create new workbooks using templates on your computer:

New Workbook Dialog Box
Installed Templates

To create new workbooks using templates on Office Online:

Online Templates