How to Insert a Template in Excel 2007

1. Hold the 'Windows' key down and press 'E' to open Windows Explorer.
2. Navigate to where you saved the template you want to insert into Excel.
3. Open another Windows Explorer window, type 'C:\Users\USERNAME\AppData\Roaming\Microsoft\Templates' in the top address field and press 'Enter.' When typing the address, change 'USERNAME' to your Windows username, which is listed beneath your picture on the 'Start' menu.Do not try to navigate into this folder by clicking folders. If you maintain Windows 7's default settings, you will not find the 'AppData' folder because it is a hidden system folder. However, by directly typing the location in the address bar, you bypass the hidden nature of the folders, which saves you the trouble of changing your Windows configuration.
4. Hold the 'Alt' key and press 'Tab' to return to the previous Windows Explorer window.
5. Click and begin dragging the Excel template file, which should have the XLTS extension.
6. Hold the 'Alt' key and press 'Tab' again to return to the template folder. Do not release your left mouse button yet.
7. Continue dragging the template file and drop it into the right pane by releasing the left mouse button. This inserts the template into Excel and makes it available for use.