Forgot to mention to open a new workbook. Adjust the settings as required and
save as Book.xlt..Refer the KB article below
http://office.microsoft.com/en-us/ex...292861033.aspx
"Jackpot" wrote:
One way is to create a template and name it "Book" . If you already have the
Book.xlt in the XlStart folder all new workbooks are created from this
template.
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
"Eric" wrote:
Does anyone have any suggestions on how to set the default format on excel
2003? such as font, size, center align, whenever I open, it is all set.
Thanks in advance for any suggestions
Eric