Creating Your Own Excel 2007 Templates

When you can’t find a ready-made Excel 2007 template that fits the bill, create your own templates from sample workbooks that you create or that your company has on hand. The easiest way to create your own template is to create an actual workbook prototype and then save the file using the template file format (.xltx). Then you can open the file from the Templates folder to create new workbooks as needed.

1

Create an Excel workbook that contains all of the elements needed for the template file.

These elements can include text, data, comments, formulas, graphics, formatting, and macros that it requires to function.

2

Click the Office button and choose Save As.

The Save As dialog box appears.

3

Type the name for the template in the File name box.

Make sure you use a descriptive name so you can easily pick it out in the future.