TEMPLATES AND STYLES WORKING WITH TEMPLATES Creating a Template Applying Templates WORKING WITH STYLES Creating a Style Applying a Style Editing a Style Deleting a Style Copying Styles from another Workbook

Working with Templates/Templates have the .XLT file extension. Templates contain layout and formatting information, including text and graphics, layouts and styles, headers and footers, formulas, and macros.

When working with spreadsheets, you may wish to use the same layout or design.  Instead of re-creating the design, you can create a template.

 Templates have the .XLT file extension. Templates contain layout and formatting  information, including text and graphics, layouts and styles, headers and footers, formulas, and macros. When templates are used to create a new Workbook, a copy is made, leaving the original template file intact for further use 

»Creating a Template

To create a Workbook that contains all layout and formatting elements needed in your template, follow these steps:

1- From the main menu, choose File   →     Save As to display the Save As dialog box.

2- In the File name dropdown list box, type a template name.

3- From the Save as type dropdown list box, select Template (*.XLT) to display the existing templates in the default Templates folder and to add the .XLT extension to the file name:

4- Click Save to save the template in the Templates folder

»Applying Templates

5- From the main menu, choose File → New to display the New Workbook pane.

6- From the New from template section of theNew Workbook pane, click on General Templates to display the Templates dialog box:

7- Click on the General or the Spreadsheet Solutions tab to locate the template you want.

8- Select the template icon you want.

9- Click OK.

◙ Working with Styles

Working with Styles

Whereas a template is a collection of layout and formatting information for a workbook, a style    is a collection of formatting information for a cell.  Styles can contain formatting information, including Number ,Font , Alignment, Border , Patterns , and Protection.

Whereas a template is a collection of layout and formatting information for a workbook, a style is a collection of formatting information for a cell.  Styles can contain formatting information, including Number, Font, Alignment, Border, Patterns, and Protection.

You can use styles to reapply the pre-defined formatting to multiple cells.  When styles are used to format cells, you can reformat the Worksheet by modifying the styles.  It is possible to copy styles from one Workbook to another.

Excel 2002 comes with a number of pre-defined styles.  By default, all cells are assigned the

Normal style.

»Creating a Style

1- Select the cell that contains the formatting you want in your style.

2- From the main menu, choose Format  →   Style to display the Style dialog box.

3- In the Style name dropdown list box, type a style name.

4- Select the attributes (Number, Alignment, Font, Border, Patterns, and Protection) you want to include in the new style:

5- Click Add to create the style

6- Click OK to close the Style dialog box.

»Applying a Style

1- Select the cell or cell range you want to format.

2- From the main menu, choose Format  → Style to display the Style dialog box.

3- From the Style name dropdown list box, select the style you want to use:

4- Click OK to close the Style dialog box.

»Editing a Style

5- From the main menu, choose Format   → Style to display the Style dialog box.

6- From the Style name dropdown list box, select the style you want to edit.

7- Click on the Modify button to display the Format Cells dialog box:

8- Use the tabs to access the attributes you want to change, and make the changes needed.

9- Click OK to return to the Style dialog box.

10- Click OK to apply the changes to all cells formatted with this style.

 

»Deleting a Style

1- From the main menu, choose Format → Style to display the Style dialog box.

2- From the Style name dropdown list box, select the style you want to delete.

3- Click on the Delete button.

4- Click OK to close the Style dialog box.

 » Copying Styles from another Workbook

1- Open the Workbook with the styles you want to copy.

2- Switch to the Workbook that the styles will be copied to.

3- From the main menu, choose Format  →  Style to display the Style dialog box.

4- Click on the Merge button to display the Merge Styles dialog box:

5- Select the Workbook that contains the styles you want.

6- Click OK to copy the styles from the selected Workbook.

     Note: If the target Workbook contains styles with the same name, the following warningmessage  will appear.  Click Yes to replace all the existing styles with the copied styles:

  

7- Click OK to close the Style dialog box.