Jump to content

Create a template


Recommended Posts

Create a template

As with Word, you can create a template in Excel for frequently used worksheets. For example, suppose that you create a new worksheet each month to record the total number of volunteer hours worked in your organization. Rather than re-create the worksheet, you can delete the text and numbers entered for the month and save the format and formulas to a template.

Follow these steps:

1. Go to File | Save As.

2. In the Save As Type text box, select Template from the drop-down list.

3. Enter your template's name in the File Name box, and click Save.

Excel saves the template to the Templates folder with an .xlt file extension. To use the template, go to File | New and double-click the template's icon.

To make changes to your template, go to File | Open and select the Templates folder from the Look In drop-down list. Select and open your template, make your changes, and click Save. The next time you access your template from File | New, the document will include the updates you made to the template.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...