How do I make a every new spreadsheet have a default template in EXCEL 07? ?
You can’t set a default template in Excel like you can in Word because Excel templates are generally very complete workbooks and Word templates tend to just establish default settings for a blank document. What you can do is to create your template and then create a short cut that opens that template. Do that by finding the .xlt file in Explorer, right clicking on it, selecting Create Shortcut, and moving or copying the shortcut to your Desktop, Quick Launch toolbar, or wherever else you want it to be. Opening a template file with a short cut results in Excel opening the file as an .xls file with a new name so the template is protected from inadvertent changes. So using the shortcut will always open new workbooks with the intended template. Ensuring that every new worksheet has a “default template” is a little different. Most of the things that you would want every worksheet (as opposed to every workbook) to have default values for should be covered in Tools > Options; but, if you want
