Microsoft Office Tutorials and References
In Depth Information
Working with Template Files
Figure 4-3: Templates that you can use for invoices.
Microsoft Office Online has a wide variety of templates, and some are better than others. If you
download a few duds, don’t give up. Even though a template may not be perfect, you can often
modify a template to meet your needs. Modifying an existing template is often easier than
creating a workbook from scratch.
The location of the Templates folder varies, depending on the version of Excel. To find
the location of your Templates folder, execute the following VBA statement:
Excel supports three types of templates:
h The default workbook template: Used as the basis for new workbooks. This file is named
h The default worksheet template: Used as the basis for new worksheets inserted into a
workbook. This file is named sheet.xltx .
h Custom workbook templates: Usually, ready-to-run workbooks that include formulas.
They can be as simple or as complex as you like. Typically, these templates are set up so
that a user can simply plug in values and get immediate results.