Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

Saving a Worksheet as a Template

After you prepare your worksheet for the template form, the next step is to save the worksheet as a template file. A template file has the file type .XLT. You need to use the Save As command to save the workbook file and change it into a template file format.

You can save your template file into three locations:

• The Templates folder, or a subfolder of the Templates folder in the Microsoft Office or Microsoft Excel folder.

• The XLStart folder in the Microsoft Excel folder.

• The location you specified as an alternate startup file location: Click the Tools menu, choose Options, click the General tab, and enter the location (folder) in the At Startup Open All Files In text box.

The practice exercise shows you how to save ...