Page 191 - Excel 2007 Bible
P. 191
13_044039 ch09.qxp 11/21/06 12:23 PM Page 148
Part I
Getting Started with Excel
FIGURE 9.3
The workbook, after 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. To open a template, choose Office ➪ Open (not File ➪ New) and locate the
template file (it will probably have an XLTX or XLT extension). Template files, by default, are stored in:
C:\Documents and Settings\<user name>\Application Data\Microsoft\
Templates
When you open a XLST (or *.XLT) template file, you are opening the actual file — you are not creating a
workbook from 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.
148