Just a couple comments:
CyberTaz said:
One Option: You can create your own custom default workbook by following the
steps outlined in Excel Help:
[Change the format and settings for new workbooks]
Create a workbook that contains the sheets, default text (such as page
headers and column and row labels), formulas, styles, custom number format,
and other formatting that you want to appear in all new workbooks.
On the File menu, click Save As.
On the Format pop-up menu, click Excel Template (.xltx).
In the Save As box, type the name Workbook, and then *clear the Append file
extension check box*.
Click the arrow button , open Microsoft Office 2008/Office/Startup/Excel,
and then click Save.
I recommend saving it in an alternate startup folder (which you specify
in Preferences/General). This has two advantages...
1) Saving user files in the Application Folder Hierarchy is
non-standard, and could lead to losing the file if you ever do a
Remove/Reinstall.
I created an XL08START folder in the
~:Library:Application Support:Microsoft:Office:
folder. That way, if I ever blow away Office, my templates will be safe.
2) Saving the file in the Application folder hierarchy will, by default,
be used by all users on your Mac. This can lead to confusion if there
are multiple users of your machine, and less fine control if you have
multiple accounts set up for different purposes.
You must quit and then reopen Excel to see the changes in a new workbook.
That *shouldn't* be necessary...
Note To restore original settings for workbooks, delete the Workbook file
from the Excel startup folder.
To temporarily reset - start XL with the Shift key down.