Editing an Excel 2007 Template

You make changes to a template just as you would make changes to a normal workbook file — simply open the file directly, make your changes, and then save the file. Template files are saved in the Templates folder by default. This folder is usually located at: C:\Users\[your user name]\Application Data\Microsoft\Templates if you are using Windows XP or, C:\Users\[your user name]\AppData\Roaming\Microsoft\Templates if you are using Windows Vista. You will need to navigate to this folder to find your existing templates. Being able to find your template files is especially handy if you want to copy your templates to another computer or make a back up of any templates that you have created or downloaded.

Another way to edit a template (although a bit sloppier) is to create a new workbook based upon the template that you want to edit. Make your changes and then save the new workbook as a Template (with the same name as the original template), as we did in the last lesson. Click Yes when asked if you wish to replace the existing file.

To Edit an Existing Template (for Windows XP Users)

1. Click the Microsoft Office button and then click Open.
2. Click Local Disk (C:) in the right pane.
3. Double-click Documents and Settings.
4. Double-click the folder with your User Name.
5. Double-click Application Data.
6. Double-click Microsoft.
7. Double-click Templates.
8. Select the desired template file and click Open.
9. Make any changes to the template.
10. Click the Save button to save your changes.

To Edit an Existing Template (for Windows Vista Users)

1. Click the Microsoft Office button and then click Open.
2. Click Computer in the Favorite Links area.
3. Click Local Disk (C:) in the right pane.
4. Double-click Users.
5. Double-click the folder with your User Name.
6. Double-click AppData.
7. Double-click Roaming
8. Double-click Microsoft.
9. Double-click Templates.
10. Select the desired template file and click Open.
11. Make any changes to the template.
12. Click the Save button to save your changes

Similar Posts:

• Editing a Word Template
• Create a New Template in Excel 2007
• Create a Template in Word 2007
• Creating an Excel 2007 Workbook Using a Template
• Create a Workspace in Excel
• Password Protect a Document in Word
• Using the Style Organizer in Word 2007

Tagged as: Excel Tips, Microsoft Office Tips