Topic 7: Excel Template - How to Create and Use it?

[seema]

Book.xlt. The default template for worksheets is called Sheet.xlt.Creating templates can include the following elements:

Text and graphics Layouts and styles formatting Headers and Footers Formulas Macros To create a template Create the workbook that contains all layout and formatting elements you wish to save as a template. From the File menu, click Save As. Type the name for the template in the File name: text box. From the Save as type: drop down list box, select Template. Select Save. The extension .XLT is added to the file name and the template is saved in the Templates folder.

Similar Threads:

• Topic 5: Using the Excel Formulas and Functions
• Topic 4: Formatting Excel data according to your needs
• Learn how to create a drop down list in an Excel cell
• How to Create Pivot Table in Excel using Desktop Office Integration
• Make used of OLE to create a new Excel File

[seema]

To use a template

From the File menu, click New to display the New Workbook pane. From the Template section of the New Workbook pane, click on the blue On my computer… link display the Templates dialog box: Click on the General or the Spreadsheet Solutions tab to locate the template you want. For default template, click on the General tab and select the Workbook icon. Note: In the Spreadsheet Solutions tab, you can see 5 templates available. Most of the times you need to use the Microsoft Office CD in order to install the features and use it. Click OK to open a copy of the template.

[seema]

Template vs Style

What is the different between Excel template and Excel style?Style is a collection of cell formatting information such as font size, patterns, alignment, etc that you can define and save as a group.
If formatting information is assigned to cells using styles it is possible to easily update the appearance of a sheet by modifying the styles.
Excel comes with a number of styles pre-defined, by default all cells have the Normal style assigned to them. It is possible to copy styles from one Workbook to another.

To create a style

Select a cell formatted with the attributes you required. From the Format menu, click Style. From the Style dialog box displayed, type the style name in the Style name: drop down list. Select the Modify ****on to change any of the attributes. The Format Cells dialog box will be displayed. Click on the Number, Alignment, Font, Border, Patterns and Protection tabs and make any changes required. Click OK to return to the Style dialog box. Click OK.

[seema]

To apply a style

Select the range of cells that you wish to format. From the Format menu, click Style. Select the style from the Style name: drop down list box. Select OK.