Insert a sheet based on a custom template (Excel 97/2000/v. X/2002/2003)

When you insert a worksheet using the Insert | Worksheet menu command, Microsoft Excel automatically bases the new sheet on the default template. However, you may not want to insert just a blank worksheet.

For instance, say your company uses a special Project Tracking template. A workbook is dedicated to each client and there could be several project worksheets in each workbook. Instead of inserting a blank sheet, you want to insert a blank Project Tracking form. Fortunately, you can select what template Excel uses to create a new worksheet. Instead of using the menu command, right-click on a worksheet tab (or [control]-click on a Mac) and then choose Insert from the shortcut menu. The Insert dialog box appears, displaying your PC's templates. Simply select the appropriate one and click OK.