12- Create & edit templates

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

121- Create & edit templates Play Video

Create a Template:

Click the Office button. Point to Save As.

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

1)    Click the Save as type list arrow. 

2)    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.

 

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.

Click Open.

 

 

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

 

Back To Top         Back To Excel Index Page     (Open Exercise file)

 

Back To Edmond Home Page