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
   186   187   188   189   190   191   192   193   194   195   196