Answer for:

Create and save default options in Excel 2007

Message 2 of 3

View entire thread
0 Votes

Follow these steps:

Create a workbook that contains the sheets, default text (such as page headers and column and row labels), formulas, macros, styles, zoom percentage, and other formatting you want in new workbooks that you base on the template.

On the File menu, click Save As.
In the Save as type box, click Template (*.xlt).
In the Save in box, select the folder where you want to store the template.

To create the default workbook template, select the XLStart folder in the Microsoft Excel folder. (You'll probably find the XLStart folder in c:\Program Files\Microsoft Office\office\ )
In the File name box, type BOOK to create a default workbook template.