6- Using templates, styles and AutoFormat

(Open Exercise file) Back To Excel Index Page Back To Edmond Home Page

61- Templates Play Video

Open a Template:

1) Click the Office button. Then click Open.

Click the Office button. Then click Open.

2) Click the Files of type list arrow and click Templates.

Click the Files of type list arrow and click Templates.

3) Microsoft Office templates are typically stored in the following location.

4)        In Windows Vista. C:/Users/your name/AppData/Roaming/Microsoft/Templates.

5)        In Windows XP. C:/Documents and Settings/your name/Application Data/Microsoft/Templates.

6)        Click the file name of the template. Click Open.

Create a Template:

1) Click the Office button. Point to Save As.

Click the Office button. Point to Save As. Click Other Formats.

2) Click the Save as type list arrow.
Select Excel Template to create a template for Excel 2007.

Click the Save as type list arrow. Select Excel Template to create a template for Excel 2007.

3) Select Excel Macro-Enabled Template to create a template for Excel 2007 with macros.

Select Excel Macro-Enabled Template to create a template for Excel 2007 with macros.

4) Select Excel 97-2003 Template to create a template for Excel 97-2003.

Select Excel 97-2003 Template to create a template for Excel 97-2003.

5) Microsoft Office templates are typically stored in the following location:

6) In Windows Vista. C:/Users/your name/AppData/Roaming/Microsoft/Templates

7) In Windows XP. C:/Documents and Settings/your name/Application Data/Microsoft/Templates

8) Type a name for your template.Click Save.

Type a name for your template.

Change an Excel Template:

1) Click the Office button. Then click New.

Click the Office button. Then click New.

2) Open the template you want to change.

Open the template you want to change.

3) Make the changes you want to the template.

Make the changes you want to the template.

4) Click the Office button and then click Save As.

Click the Office button and then click Save As.

5) Click the Save as type list arrow and click Excel Template.

Click the Save as type list arrow and click Excel Template.

6) The location defaults to the folder for My Templates.

The location defaults to the folder for My Templates.

7) Type a file name. Click Save

Type a file name. Click Save

62- Styles Play Video

Apply a Cell Style:

Ø Select a cell or a range.

Click the Home tab.

Click the Cell Styles button.
Click the cell style you want to apply.

Click the Home tab. Click the Cell Styles button. Click the cell style you want to apply.

2) Create a Custom Cell Style

3)    Select a cell or a range.
           Click the Home tab.
           Click the Cell Styles button and then click New Cell Style.

Click the Home tab. Click the Cell Styles button and then click New Cell Style.

4) Type a name for the cell style.
Click Format.

Type a name for the cell style. Click Format.

5) The Format Cells dialog box opens.
Make the changes on the Number, Alignment, Font, border, Fill, and Protection tabs, and then click OK.

The Format Cells dialog box opens. Select the formatting on the Number, Alignment, Font, border, Fill, and Protection tabs, and then click OK.

6) Click OK again.

Click OK.

Delete a Cell Style:

1)    Click the Home tab.
           Click the Cell Styles button.
           To delete the cell style, right-click the cell style, and then click Delete.

Click the Home tab. Click the Cell Styles button. To delete the cell style, right-click the cell style, and then click Delete.

Merge Cell Styles:

1) Click the Home tab. Click the Cell Styles button and then click Merge Styles.

Click the Home tab. Click the Cell Styles button and then click Merge Styles.

2) Click the workbook that contains the styles you want to merge.
Click OK.

Click the workbook that contains the styles you want to merge. Click OK.

Modify a Custom Cell Style:

1) Click the Home tab. Click the Cell Styles button.
Right-click the custom cell style and then click Modify.

Click the Home tab. Click the Cell Styles button. Right-click the custom cell style and then click Modify.

2) To create a new style based on an existing style, type a name for the cell style.
Click Format.

To create a new style based on an existing style, type a name for the cell style. Click Format.

3) The Format Cells dialog box opens.
Make the changes on the Number, Alignment, Font, border, Fill, and Protection tabs, and then click OK.

Select the formatting on the Number, Alignment, Font, border, Fill, and Protection tabs, and then click OK.

Remove a custom cell style from a cell:

1)    Select the cell or a range.
           Click the Home tab.
           Click the Cell Styles button.
           Then click Normal.

Click the Home tab. Click the Cell Styles button. Then click Normal.

2) Check the result.

Click the Home tab. Click the Cell Styles button. Then click Normal.

63- Autoformat Play Video

Change AutoFormat options:

1) Click the Office button, click Excel Options

Click the Office button, click Excel Options

2) Click Proofing in the left pane, click AutoCorrect Options

Click Proofing in the left pane, click AutoCorrect Options

3) Click the AutoFormat As You Type tab,
select or clear options, and then click OK.

Click the AutoFormat As You Type tab, select or clear options, and then click OK.

Back To Edmond Home Page