Creating Your Own Template

You can save yourself lots of time by saving your favorite workbook as a template. Simply take an existing Excel workbook, get it to look the way you want for a template form, and then create a template from it.

For example, suppose you have a budget that you update monthly. You can delete all the numbers that change in the worksheet, leaving the column and row headings intact. Then save the budget worksheet as a template. The next time you want to use the budget worksheet, open the budget template worksheet and just fill in the numbers . It's as easy as pie!

If you follow the next few steps, you prepare the Summary worksheet in the My Budget workbook (the workbook you have been working on the past 2 chapters) for a template form. You need to delete the numbers and keep the column and row headings.

  1. To open the My Budget workbook, which contains the Summary worksheet, click the Open button on the Standard toolbar. The Open dialog box appears.

  2. To select the file, double-click on My Budget.xls. The My Budget workbook appears in the Excel window. Notice that the worksheet contains column and row headings and data.

  3. Select the range that contains the data you want to delete; in this case, select the range B4:B5.

  4. Press Delete. Now press the right-arrow key to deselect the range. The data disappears. You want to keep the title, column headings, and row headings, and date (see Figure 45.7). Now the worksheet is ready to be saved as a template (as explained in the next section).

    Figure 45.7. The worksheet without numbers, with the title, column headings, and row headings, ready for the template form.


Sams Teach Yourself Office Productivity All in One
Sams Teach Yourself Office Productivity All in One (Sams Teach Yourself All in One)
ISBN: 0672325349
EAN: 2147483647
Year: 2003
Pages: 474
Authors: Greg Perry © 2008-2017.
If you may any questions please contact us: