CATEGORY: Excel Worksheet, Workbook VERSIONS: All Microsoft Excel Versions

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

Rate this tip 1 2 3 4 5   RATING: 3.47   VIEWS: 13118 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

Microsoft Windows XP Inside Out Special Edition Using Microsoft Access 2002 Financial Peace: Revisited AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner Accounting Principles, with CD, 6th Edition

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books