Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Help and How-to
Search
Search
 
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Use and save an Excel template
 
  1. On the File menu, click New, and then click General Templates.
  2. In the Templates dialog box, click the tab that contains the template (template: A workbook that you create and use as the basis for other similar workbooks. You can create templates for workbooks and worksheets. The default template for workbooks is called Book.xlt. The default template for worksheets is called Sheet.xlt.) for the form, and then double-click the template.

    If the template for your form is not displayed on one of the tabs, make sure the template is stored in your Templates folder or one of its subfolders, or ask your system administrator how to find and use the form.

  3. Enter the requested information, and follow any other instructions in the form.
  4. Click Save Button image.
  5. In the Save in box, open the folder where you want to store your copy of the form.

    If the form is used by others in your group and you want to save your copy of the form in a shared network location, ask your system administrator where you should save your copy of the form and whether you should follow any file naming conventions.

  6. In the File name box, type a name for the form, and then click Save.

    If the form has been designed to copy your entered data to a database, a message is displayed asking whether you want to add your data as a new database record. To add your data, click Yes.

advertisement