Tip Printed from ExcelTip.com

---

Saving a Customized Workbook as a Template in Excel 2007


Why it is important to save a customized workbook as a template?

To allow you to save custom Styles.
To allow you to save Print Setup options as Header/ Footer themes.
To enable many users to use the same design and structure.

To save a workbook as a template:

1. Select File -> Save As.
2. In Save As dialog Box, In the File name box, type a name for the new template file
3. From Save As type box select Excel Template, and click Save.
4. Close the open template workbook.