Part I: Getting Started with Excel
164
FIGURE 8.3
The workbook, after customizing it and entering some information.Modifying a template...............................................................................................
A template file is just like a workbook file. As such, you can open a template file, make changes to
it, and then resave the template file. Looking at the invoice template shown earlier in this chapter,
you may want to modify it so that it shows your company information and uses your actual sales
tax rate. Then, when you use that template in the future, the workbook created from it will already
be customized.To open a template, choose File ➪ Open (not File ➪ New) and locate the template file (it will have
an .xltx or .xlt extension).Tip
The location for template files varies. To find out where Excel stores template files, open a new workbook and
choose File ➪ Save As. In the Save As dialog box, choose Excel Template (*.xltx) from the Save as Type drop-
down list. Excel will activate your template folder. Make a note of this location, and click Cancel to close the
Save As dialog box. On my system, templates are stored here:
C:\Users\<username>\AppData\Roaming\Microsoft\Templates