EXCEL VIDEO TUTORIALS / EXCEL DASHBOARD REPORTS

Ozgrid, Experts in Microsoft Excel Spreadsheets

Create an Excel Worksheet Template

| | Information Helpful? Why Not Donate.

 

Creating Excel Templates Explained

EXCEL WORKSHEET TEMPLATES See also Create Excel Workbook Templates

Worksheet templates are used to store settings you want to appear on all new sheets of the same type.  The default worksheet template is stored as sheet.xlt.  When you create a template for a worksheet, Excel uses the template to create blank worksheets when you insert a new sheet to a workbook.
 
To create a worksheet template:
 
Create a new Excel workbook containing one worksheet
One the worksheet specify all required settings
Go to File>Save As
In the Save as type box, select Template
In the Save in box, select the folder you wish to store your template in.

SAVING TO THE XLStart FOLDER
 
If you want your template to be available as soon as you Start Excel, you need to save directly to the XLStart folder, usually located at:
 
C:\Program Files\Microsoft Office\Office11\XLStart
 
SAVING TO THE TEMPLATES FOLDER
 
If you wish your template to be available in the Templates dialog, try the following:
 
Create a new Excel workbook or worksheet
Specify all required settings
Go to File>Save As
Locate the Templates Folder, usually C:\Documents and Settings\user_name\Application Data\Microsoft\Templates
In the Save as type box, select Template
Give your template a name.
 
This will force your template to appear in the Templates dialog under the General tab. 
 
Note: Sometimes, due to network restrictions, the Templates folder cannot be seen.  If this happens to you, you need to contact your network administrator.
 
You can go one step further and create a new folder within the Templates folder C:\Documents and Settings\user_name|Application Data\Microsoft\Templates and move your template to that folder.  This will create a new tab on the templates dialog.
 

 
 
To remove a template, you need to locate the folder that it is saved in and delete it.
 
USEFUL TEMPLATES

See our huge range of Excel Templates

Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.


Instant Download and Money Back Guarantee on Most Software

EXCEL VIDEO TUTORIALS / EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates