O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required