Inserting a New Sheet from a Template Sheet

For an explanation on how to create and save a new template workbook.
In this example, the template workbook name is Book.xlt
(except for Excel 2000, where the template workbook name will be Sheet.xlt).

To define a new customized sheet to be used as the default inserted sheet:

1. Insert new sheets from a template named Book.xlt by right-clicking a sheet tab, and selecting Insert from the shortcut menu.
2. Double-click Book.xlt.
3. Delete all sheets except one.
4. Save the workbook as a template with the name Sheet.xlt, and then close it.

To insert one template sheet into a workbook:

1. Right-click any sheet tab, and select Insert from the shortcut menu.
2. In the Insert dialog box, select the template Sheet.xlt and click OK. The inserted sheet is the customized sheet template.
Screenshot // Inserting a New Sheet from a Template Sheet
Inserting a New Sheet from a Template Sheet

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube