Creating an Excel 2007 Workbook Using a Template

by rhyttinen on February 24, 2009

Excel includes a few pre-defined templates which automate the process of creating common forms such as invoices, expense statements, loan amortization, time cards and balance sheets. This is especially helpful if you find yourself creating the same type of report over and over again. To use a template, create a new workbook based on a template and fill in the data – the design and formatting process is already done for you. You can use the installed templates that came with Excel or download hundreds of additional templates from Microsoft Office Online.

New Workbook dialog box

To Create a Workbook from a Template

  1. Click the Microsoft Office Button and then click New.
  2. Click Installed Templates in the left pane.
  3. Click the template you want and then click the Create button.
  4. To view additional templates from Microsoft Office Online:
    a. Under the Microsoft Office Online category in the left pane, click the template category.
    b. Select the template you want to use.
    c. Click Download to install the template on your computer.

Similar Posts:

Share and Enjoy:
  • del.icio.us
  • Digg
  • TwitThis
  • Reddit
  • Technorati
  • Facebook
  • StumbleUpon
  • Google Bookmarks
  • Propeller
  • email

Comments on this entry are closed.

Previous post:

Next post: