Set default settings for Excel 2003
I received many positive responses from my blog article about setting the default font in Microsoft Word. I received this question from a reader:
Thanks for all the intelliAdmin posts - I enjoy your blog and find it very helpful. I have a question specifically about your post about setting the default Word font. Do you have any similar things for Excel? It seems to be a lot more difficult to do for some reason.
I knew this was possible, but I have not done it for quite some time. After doing some research I discovered this can be accomplished by creating a Book.xlt file.
It is not as elegant as the Normal.dot in Microsoft Word, since it works system wide, and you cannot have different default settings for different users (If you know a way please let me know)
Lets say I have a specific font I want all new Excel documents to use. Simply open Excel, and create a new document. Set the default font.

Any changes you make to this workbook will become the default after we are done. So set it…
Click to continue reading "Set default settings for Excel 2003"
Written by Steve Wiseman on September 18th, 2007 with no comments.
Read more articles on software.















